what is an outer join? difference between left outer join
right outer join with an example?
- 1 Answers
- 10279 Views
- HCL, I also Faced
- E-Mail Answers
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 |
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
Explain about scorecarding?
2.How do you drill through report from Report Studio to Analysis studio?
How can we change any header or footer for a group of reports
1 Answers Satyam, Tech Mahindra,
what is the difference between aggregation and roll up aggregation?
what are determinants?
can any one say the which is the best performance in framework manager
what is requery in cognos?
what is logs in cognos
1 Answers Target, Thomson Reuters,
Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin
What is the difference between a data mart and a data warehouse?
hi,dis is kumari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is vicky_ceti@yahoo.co.in hope u will respond as soon as possible. thank u in advance
Teradata 
