SELECT * FROM OrderItems WHERE quantity = 100 UNION SELECT * FROM OrderItems WHERE prod_id LIKE 'BNBG%' ORDER BY prod_id ASC # 愣是没懂“过滤数量为100的行”,笑死
SELECT * FROM OrderItems WHERE quantity = 100 UNION SELECT * FROM OrderItems WHERE prod_id LIKE 'BNBG%' ORDER BY prod_id ASC # 愣是没懂“过滤数量为100的行”,笑死