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