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 ARE THE DISTNICT VARIABLES?
Can you explain cognos planning?
----------------------What are the User Securities?
5. Which type of report you build more, list, crosstab or chart and why?
What do you understand by user class in cognos?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
what is stitch query in reportnet?
How can we create a dynamic column name in cognos?
What junk dimension contains?
What are all the types of indexes in Cognos?
What is called Cognos powerplay?
What is the use of Cognos scenario?
How to create model and how to test model?
----------------Diff b/w Dimensional modeling and Relational modeling?