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

Transcribed Image Text:

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