¡¼Inner Join
USE AdventureWorks;
GO
SELECT *
FROM HumanResources.Employee AS e
    INNER JOIN Person.Contact AS c
    ON e.ContactID = c.ContactID
ORDER BY c.LastName

¡¼Left outer join
To include all products, regardless of whether a review has been written for one, use an SQL-92 left outer join. The following is the query:

USE AdventureWorks;
GO
SELECT p.Name, pr.ProductReviewID
FROM Production.Product p
LEFT OUTER JOIN Production.ProductReview pr
ON p.ProductID = pr.ProductID

¡¼Left outer join
SELECT *
FROM   GOLDEN_SILVER_MEMBER ta LEFT OUTER JOIN VOLUME tb 
ON     ta.sa_ss      = tb.sa_ss 
AND    ta.period_end = tb.period_end


¡¼Right outer join
To include all sales persons in the results, regardless of whether they are assigned a territory, use an SQL-92 right outer join. Here is the Transact-SQL query and results of the right outer join:

USE AdventureWorks;
GO
SELECT st.Name AS Territory, sp.SalesPersonID
FROM Sales.SalesTerritory st 
RIGHT OUTER JOIN Sales.SalesPerson sp
ON st.TerritoryID = sp.TerritoryID ;