LISTING 1: Query That Uses a 5-Table Join to Return Order Details
SELECT CAT.CategoryName,
      P.ProductName,
      OD.Quantity,
      O.OrderID,
      C.CompanyName
FROM dbo.Orders AS O
   INNER JOIN dbo.[Order Details] AS OD
      ON O.OrderID = OD.OrderID
   INNER JOIN dbo.Products AS P
      ON P.ProductID = OD.ProductID
   INNER JOIN dbo.Categories AS CAT
      ON P.CategoryID = CAT.CategoryID
   INNER JOIN dbo.Customers AS C
      ON C.CustomerID = O.CustomerID