List the possible orders to join the Rep, Customer, Orders, Order_Line tables when execuring the following...

 

Transcribed Image Text:

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 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