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 

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!