-- Listing 3: Solution That Uses Conventional Join Techniques
SELECT C.companyname, O.orderid, P.productname, OD.qty
FROM Customers AS C
  LEFT OUTER JOIN Orders AS O
    ON O.custid = C.custid
  LEFT OUTER JOIN OrderDetails AS OD
    ON OD.orderid = O.orderid
  FULL OUTER JOIN Products AS P
    ON P.productid = OD.productid