Question: List the possible orders to join the Rep, Customer, Orders, Order_Line tables when execuring the following SQL query. It uses the database described on
List the possible orders to join the Rep, Customer, Orders, Order_Line tables when execuring the following SQL query. It uses the database described on page 4. SELECT Item_num, Num_ordered, L.Order_num, Order_date, C. Customer num, Customer_name, Last_name FROM Order_Line L, Orders 0, Customer C, Rep R WHERE O.Order num = L.Order num AND C. Customer_num = O. Customer num AND R. Rep_num = C.Rep_num ORDER BY Item num, L.Order_num
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
