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

suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?

2 Answers   Mind Tree,


What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

0 Answers  


What are all the different types of prompt in cognos?

0 Answers  


How can we improve performance in framework manager level?

3 Answers   Wipro,


1.How to apply sorting to Crosstab report? If so please give me example? 2.How to create Report level Joins?explain with example?

2 Answers   Cognizant,


Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?

5 Answers   Mphasis,


what is your project workflow and your role in the project?

5 Answers   Syntel,


How many fact tables and dimension tables in your project?

3 Answers   IBM,


Can any one give the example for slicing and dicing of data ?(with simple query)

3 Answers   Cognos,


1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer.

2 Answers   Satyam,


What are the components of the report studio?

0 Answers  


What is Render Variable? where u can use?

3 Answers  


Categories