select Orders.cust_id,Orders.order_date from OrderItems,Orders where OrderItems.order_num = Orders.order_num and OrderItems.prod_id="BR01" order by Orders.order_date 两表进行关联，关联条件为order_num，然后添加条件prod_id="BR01"，再进行排序
select Orders.cust_id,Orders.order_date from OrderItems,Orders where OrderItems.order_num = Orders.order_num and OrderItems.prod_id="BR01" order by Orders.order_date 两表进行关联，关联条件为order_num，然后添加条件prod_id="BR01"，再进行排序
牛客博客，记录你的成长
京公网安备 11010502036488号