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
- 5429 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
What are the differences between having and where clause.
What is sql server programming?
What do you mean by a dependent functionality in a build?
please differentiate between delete and truncate?
What is the recovery model? List the types of recovery model available in sql server?
What is meant by dirty read?
How to write a query with a left outer join in ms sql server?
What are translations and its use? : sql server analysis services, ssas
what are the three command line utilities and what are their primary functions?
What is sql server used for?
What is a trigger? Why we need it?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
Explain transaction server explicit transaction?
What is PROJECTION Operation?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
