SELECT Customer.cust_id, Customer.company, Customer.country,;
  Orders.order_id;
 FROM  testdata!orders LEFT OUTER JOIN testdata!customer ;
   ON  Orders.cust_id = Customer.cust_id