# 简单等连接查询，用where包装连接条件和查询条件
select cust_id, order_date
from OrderItems oi, Orders o
where oi.order_num=o.order_num
and prod_id='BR01'
order by order_date;