what is an outer join? difference between left outer join
right outer join with an example?
Answer Posted / 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 View All Answers
What is zero-foot print?
-------------What is Coditional Prompting?
How to apply securities for reports in cognos connection?
What are the types of hierarchies?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
How to create model and how to test model?
Can you define set to be cardinality?
how u will design the report if the objects are available
What do you mean by drill through report?
tell me two or three issues from client side and how to solve those issues?
What is dtm?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
What is called materialized view?
Can you define pivot?