Working examples for outer join & self join in SQL server?

Question

Examples along with the tables which have been used to write the particular queries for outer join and self join?

Answer 1

LISTING 3: RIGHT OUTER JOIN Query That Returns Orders With Valid CustomerIDs
SELECT C.FirstName
AS CustomerFirstName,
O.ProductID
FROM dbo.Customer AS C
RIGHT OUTER JOIN dbo.[Order] AS O
ON C.CustomerID = O.CustomerID

LISTING 1: INNER JOIN Query That Returns Customers Who Have Placed Orders
SELECT C.FirstName
AS CustomerFirstName,
O.ProductID
FROM dbo.Customer AS C
INNER JOIN dbo.[Order] AS O
ON C.CustomerID = O.CustomerID

Answer 2

assuming which you have 2 tables with precisely comparable column, i could advise which you carry out UNION rather of OUTER connect. decide on * from coachs UNION decide on * from gamers; could consequence like what you specify. the alternative could be utilising decide on INTO statements for each table to fill the information into the objective table and do wide-spread question : decide on * from purpose;