# 将两个查询语句结果合并，使用到union
select * from OrderItems where quantity=100
union
select * from OrderItems where prod_id like 'BNBG%'
order by prod_id;