Interested to Buy Any Domain ? << Click Here >> for more details...
A left outer join B
B right outer join A gives the same result then what is
the use of two?
- 1 Answers
- 5276 Views
- I also Faced
- E-Mail Answers
Answer Posted / nithya
Is ur query used in any situation? bcos
In general join is used in the following case:
consider "Persons" table:
P_Id LastName FirstName Address City
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger
"Orders" table:
O_Id OrderNo P_Id
1 77895 3
2 44678 3
3 22456 1
4 24562 1
5 34764 15
left outer join:
SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
FROM Persons
LEFT outer JOIN Orders
ON Persons.P_Id=Orders.P_Id
ORDER BY Persons.LastName
The result-set will look like this:
LastName FirstName OrderNo
Hansen Ola 22456
Hansen Ola 24562
Pettersen Kari 77895
Pettersen Kari 44678
Svendson Tove
right outer join:
SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
FROM Persons
RIGHT JOIN Orders
ON Persons.P_Id=Orders.P_Id
ORDER BY Persons.LastName
The result-set will look like this:
LastName FirstName OrderNo
Hansen Ola 22456
Hansen Ola 24562
Pettersen Kari 77895
Pettersen Kari 44678
34764
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain throw statement in sql server 2008?
What are different types of statement?
How do I edit a procedure in sql server?
How many primary keys are possible in a table?
What is the difference between left and right outer join?
What is difference between delete & truncate commands?
Explain mixed authentication mode of sql server?
Where do we use trace frag?
How can I change procedure name in sql server?
How many types of functions are there in sql server?
What are the different types of backups that exist?
Can we use where and having clause together?
What is the difference between grant and with grant while giving permissions to the user?
what are constraints? Explain different types of constraints? : Sql server database administration
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
