select O.cust_id,O.order_date
from 
(select order_num from OrderItems where prod_id = 'BR01') OI
join Orders O 
on OI.order_num = O.order_num
order by O.order_date