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