题解 | #将两个 SELECT 语句结合起来（一）#

select prod_id,quantity
from OrderItems
where OrderItems.quantity=100
union
select prod_id,quantity
from OrderItems
where OrderItems.prod_id like "BNBG%"
order by prod_id asc