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: 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
Get step-by-step solutions from verified subject matter experts
