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, c.company, 
     c.phone, u.call_dtime, u.call_descr
   FROM customer c, cust_calls u
   WHERE c.customer_num = u.customer_num;