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

输入：

DROP TABLE IF EXISTS `OrderItems`;
CREATE TABLE IF NOT EXISTS `OrderItems`(
	prod_id VARCHAR(255) NOT NULL COMMENT '产品id',
	quantity VARCHAR(255) NOT NULL COMMENT '商品数量'
);
INSERT `OrderItems` VALUES ('a0001',105),('a0002',100),('a0002',200),('a0013',1121),('a0003',10),('a0003',19),('a0003',5),('BNBG',10002);

(SELECT
	* 
FROM
	OrderItems 
WHERE
	quantity = 100 )
union
(SELECT
	* 
FROM
	OrderItems 
WHERE
	prod_id LIKE 'BNBG%')
order by prod_id

输出：