获取到prod_id="BR01"的订单号

select order_num from OrderItems where prod_id="BR01"

把需要获取的内容写在外层，将订单编号的条件进行子查询 select cust_id,order_date from Orders where order_num in (select order_num from OrderItems where prod_id="BR01")