The sel_join.sql command file

The following example command file uses a simple join on the customer and cust_calls tables. This query returns only those rows that show the customer has made a call to customer service.
SELECT c.customer_num, c.lname,,, u.call_dtime, u.call_descr
   FROM customer c, cust_calls u
   WHERE c.customer_num = u.customer_num;

Copyright© 2018 HCL Technologies Limited