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
What is the difference between a fill factor of 100 and 0?
Do you know what are pages and extents? : SQL Server Architecture
What are the different normalization forms?
What is the server name for sql management studio?
What is it unwise to create wide clustered index keys?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
What is normalization of database?
What does asynchronous call backs means?
Explain linked server in sql?
Explain contrast amongst grouped and non-bunched records?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
What is the default schema of your login session in ms sql server?
Why use “in” clause in sql server?
Is candidate a key?
Which database stores information about replication?