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 a transaction and what are acid properties? : Sql server database administration
What are the new features of sql server 2012 reporting service?
What is the difference between Triggers and Stored Procedure?
When cursors are useful?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is the difference between drop table and truncate table?
What is replace and stuff function in sql server?
What is abstracting periodical?
what is a self join? : Sql server database administration
Why I have to use stored procedures?
What is scrollable cursor?
Can we use trigger new in before insert?
What are various limitations of the views?
Tell me what is normalization? Explain different forms of normalization?