A left outer join B
B right outer join A gives the same result then what is
the use of two?
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
What are types of scd? : sql server analysis services, ssas
Does sql server 2000 full-text search support clustering?
How to create view in stored procedure sql server?
What is the difference between set and select?
What is a full text index?
How do users use Report Builder with SQL Server data sources?
What is a scheduled job or what is a scheduled task?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is attribute relationships, why we need it? : sql server analysis services, ssas
Which Model uses the SET concept
Describe in brief authentication modes in sql server.
What is a db view?
What is difference between count (*) and count 1?
Can you tell me about the concept of ER diagrams?
What is use of except clause? How it differs from not in clause?