Tools/WinSN5.0Ver.iso/VFP50/SAMPLES/DATA/COMBOJ.QPR

Text File | 1996-08-01 | 244 b | 6 lines

SELECT Customer.company, Orders.order_id, Orditems.line_no;
 FROM  testdata!customer LEFT OUTER JOIN testdata!orders;
    INNER JOIN testdata!orditems ;
   ON  Orders.order_id = Orditems.order_id ;
   ON  Customer.cust_id = Orders.cust_id