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
- 5327 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
User wants only to display only pdf as export option in report manager. How to achieve this?
Explain various data region available in ssrs with their use?
what are the types of indexes? : Sql server database administration
What is the use of partition by in sql server?
What are the characteristics of modern DBMS?
How can sql server instances be hidden?
How to create a new login name in ms sql server?
List the ways in which dynamic sql can be executed?
What are the dmvs?
What are ddl triggers and types of ddl trigger?
What happens when transaction log is full?
Explain subquery and state its properties?
What are different types of roles provided by ssrs?
Can I disable or restrict ssrs export formats (rendering formats)?
What is a coalesce function?
