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 downside of using udf?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What do you mean by an execution plan? Why is it used?
How to identify current user in ssrs report?
List all the types of user-defined functions?
Define primary key?
What is the difference function and stored procedure?
Can I delete event logs?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is difference between createstatement and preparedstatement?
How to use group functions in the select clause in ms sql server?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What does Master database contains?
What are the different authentication modes in sql server? How can it be changed?
What are the advantages of using a stored procedure?