题解 | prod_id 为 BR01 的产品（一）#

select a.cust_id ,a.order_date from Orders as a right join OrderItems as b on a.order_num = b.order_num where b.prod_id = 'BR01'

select a.cust_id ,a.order_date from Orders as a  inner join OrderItems as b where a.order_num = b.order_num and b.prod_id = 'BR01'


select a.cust_id ,a.order_date from Orders as a right join OrderItems as b on a.order_num = b.order_num where b.prod_id = 'BR01'

2、先把两个表的数据弄在一起 后面不久好解决了嘛？重点是怎么把两个表合并成一张表