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

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