Content Supported by Sourcelens Consulting

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