Explain the difference in using inner join and outer joins?
Submitted by: AdministratorInner join : An inner join (sometimes called a "simple join") is a
join of two or more tables that returns only those rows that satisfy the join condition.
Outer Joins : An outer join extends the result of a simple join. An
outer join returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition
Submitted by: Administrator
join of two or more tables that returns only those rows that satisfy the join condition.
Outer Joins : An outer join extends the result of a simple join. An
outer join returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition
Submitted by: Administrator
Read Online SQR (Structured Query Reporter) Job Interview Questions And Answers
Top SQR (Structured Query Reporter) Questions
| ☺ | Tell me What is search Record? |
| ☺ | Can you explain Outer join, inner join in sql? |
| ☺ | Explain the difference between Load Look up and Array? |
| ☺ | How to generate tow output files from one SQR? |
| ☺ | Explain difference between BI, CI, IB? |
Top PeopleSoft Categories
| ☺ | PeopleSoft HRMS Interview Questions. |
| ☺ | PeopleSoft Financials Interview Questions. |
| ☺ | Peoplesoft Security Interview Questions. |
| ☺ | Peoplesoft Tools Interview Questions. |
| ☺ | PeopleSoft Common Interview Questions. |
