Joining more than two tables

joining_more_than_2_tables.sql

--INNER JOIN multi-table join example
SELECT
  p.Name AS ProductName,
  pc.Name AS CategoryName,
  ps.Name AS SubcategoryName

FROM
  Production.Product AS p
  
  INNER JOIN
    Production.ProductSubcategory AS ps
      ON 
        p.ProductSubcategoryId = ps.ProductSubcategoryId
  INNER JOIN
    Production.ProductCategory AS pc
      ON
        ps.ProductCategoryId = pc.ProductCategoryId

ORDER BY
  ProductName, 
  CategoryName, 
  SubcategoryName
  
--OUTER JOIN multi-table join example
SELECT
  p.Name,
  sod.SalesOrderDetailId

FROM
  Production.Product AS p
  
  LEFT OUTER JOIN
    Sales.SAlesOrderDetail AS sod
      ON
        p.ProductId = sod.ProductId
  LEFT OUTER JOIN
    Sales.SpecialOffer AS so
      ON
        sod.SpecialOfferId = so.SpecialOfferId

ORDER BY
  p.Name, sod.SalesOrderDetailId;