/** select c.cust_name cust_name, o.order_num order_num from Customers c, Orders o where c.cust_id = o.cust_id order by cust_name,order_num; */ select cust_name,order_num from Customers c inner join Orders o on c.cust_id = o.cust_id order by cust_name,order_num;