My apologies, I meant can I have list of orders which includes the product ids from the orders placed?
select t1.order_id ,t2.product_id from orders as t1 join order_items as t2 on t1.order_id = t2.order_id
No. Is it possible to only receive results from orders placed from 1975-01-01 to 1976-01-01?
select t1.order_id ,t2.product_id,t1.date_order_placed from orders as t1 join order_items as t2 on t1.order_id = t2.order_id where t1.date_order_placed > = "1975-01-01" and t1.date_order_placed < = "1976-01-01"