select cust_id, order_date
from Orders o
join OrderItems oit
on o.order_num = oit.order_num
where oit.prod_id = 'BR01'
order by o.order_date;

MySQL优化中提到，尽量不使用嵌套查询，而是使用联结（连接）查询