Question: List all the cusomters' name, their corresponding order dates. and the purchased product ids in the output, when order dates are after 2008-09-30. (Use EQUI


 List all the cusomters' name, their corresponding order dates. and the purchased product ids in the output, when order dates are after 2008-09-30. (Use EQUI JOIN). Fill in the blanks.

SELECT cust_name, order_date, product_id

FROM customer_T, ___________, __________

WHERE _______________.cust_id = ___________.cust_id AND order_T.__________ = orderline_T._______ AND order_date _____________'2008-09-30';

V customer_order customer cust_id : int(11) cust_name : varchar(100) @street: varchar(30) @city:

V customer_order customer cust_id : int(11) cust_name : varchar(100) @street: varchar(30) @city: varchar(50) state varchar(50) zip : char(5) V customer_order product product_id: int(11) product_name : varchar(50) #product_price: double customer_order orders order_id: int(11) order_date: date #cust_id : int(11) customer_order orderLine order_id: int(11) product_id : int(11) # quantity: int(11)

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!