SELECT cust_id, order_date
FROM OrderItems O1
LEFT JOIN Orders Ors on O1.order_num = Ors.order_num
where prod_id ='BR01'
ORDER BY order_date asc