what is an outer join? difference between left outer join
right outer join with an example?



what is an outer join? difference between left outer join right outer join with an example?..

Answer / m m naidu

OUTER JOIN: It is used to retrieve all the rows from one
table but matched rows from another table

LEFT OUTER JOIN: It displays matched row from two tables
and unmatched row from left hand side table

EX: select a.empno,a.ename,a.sal,b.deptno,b.dname,b.loc
from emp a left outer join dept b on(a.deptno=b.b.deptno)

RIGHT OUTER JOIN: It displays matched rows from two tables
and unmatched row from right hand side table

EX: select a.empno,a.ename,a.sal,b.deptno,b.dname,b.loc
from emp a right outer join dept b on(a.deptno=b.b.deptno)

Is This Answer Correct ?    15 Yes 5 No

Post New Answer

More Cognos Interview Questions

what is the difference between cascading prompt and drill-thru

4 Answers  


Give the advantages of cognos?

0 Answers  


what are slowly changing dimensions? Why we are used scd?

0 Answers   IBM,


Can you define framework manager?

0 Answers  


wHAI IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB REPORT?

7 Answers  


faq's on cognos

0 Answers  


what is materialised view? why we use it in data warehousing?

5 Answers   HCL,


what is difference btw summary filter and detail filter, plz explain with example

10 Answers   IBM, TCS,


What r the names of the reports that you prepared?

0 Answers  


How to test reports in cagonos ?

10 Answers   CST, CTS,


What are the batches and it’s details?

0 Answers  


How can we improve performance in report studio level?

1 Answers  


Categories