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

select prod_id,quantity from OrderItems 
where quantity in
(
    select quantity from OrderItems 
    where prod_id like 'BNBG%' 
    or quantity = 100
) 
order by prod_id

select * from OrderItems where quantity = '100' union select * from OrderItems where prod_id like 'BNBG%' order by prod_id ; 两种写法

注意第一种写法是 from 之后where A in （ select A from 注意格式