13.SQL必知必会第14课 组合查询(union & 用union做 full outer join)
二、课后习题select prod_id,quantity from tyqsl2.orderitemswhere quantity = 100unionselect prod_id,quantity from tyqsl2.orderitemswhere prod_id like 'BNBG%'2.select prod_id,quantity from tyqsl2.orderitemswhere quantity = 100or prod_id like 'BNBG%