cross join vs full outer join code example

Example 1: full outer join sql

SELECT C.FirstName, C.LastName, C.Country AS CustomerCountry,        S.Country AS SupplierCountry, S.CompanyName  FROM Customer C FULL JOIN Supplier S     ON C.Country = S.Country ORDER BY C.Country, S.Country

Example 2: right outer vs left outer join

LEFT OUTER JOIN:
is used when retrieving data from
multiple tables and will return
left table and any matching right table records.

RIGHT OUTER JOIN:
is used when retrieving data from
multiple tables and will return right
table and any matching left table records

Tags:

Sql Example