home *** CD-ROM | disk | FTP | other *** search
/ Total C++ 2 / TOTALCTWO.iso / vfp5.0 / vfp / samples / data / comboj.qpr next >
Text File  |  1996-08-21  |  244b  |  6 lines

  1. SELECT Customer.company, Orders.order_id, Orditems.line_no;
  2.  FROM  testdata!customer LEFT OUTER JOIN testdata!orders;
  3.     INNER JOIN testdata!orditems ;
  4.    ON  Orders.order_id = Orditems.order_id ;
  5.    ON  Customer.cust_id = Orders.cust_id
  6.