What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance....

Answer Posted / j.jyothy

Already i explained 3 joins now i tell u Outerjoins.
leftouterjoin:It will display all the rows of left table
irrespective of whether there is a match in the right or
not.If there is no match in the right table then the null
row is aasumed and it is displayed in the output.

Display all emps in the emptable.
select empno,ename,esal,e.deptno,d.deptno,dname,loc from
emp e left outerjoin dept d on e.deptno=d.deptno

RightOuterJoin:It will display all the rows of right table
irrespective of whether there is a match in the right or
not.If there is no match in the Left table then the null
row is aasumed and it is displayed in the output

Example
select empno,ename,esal,e.deptno,d.deptno,dname,loc from
emp e right outerjoin dept d on e.deptno=d.deptno

Is This Answer Correct ?    23 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between a fill factor of 100 and 0?

508


Do you know what are pages and extents? : SQL Server Architecture

524


What are the different normalization forms?

589


What is the server name for sql management studio?

451


What is it unwise to create wide clustered index keys?

565






What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

517


What is normalization of database?

581


What does asynchronous call backs means?

601


Explain linked server in sql?

660


Explain contrast amongst grouped and non-bunched records?

497


Issues related in upgrading SQL Server 2000 to 2005 / 2008

1482


What is the default schema of your login session in ms sql server?

571


Why use “in” clause in sql server?

534


Is candidate a key?

507


Which database stores information about replication?

534