SELECT DISTINCT productName, listPrice
FROM product
WHERE productID IN (SELECT productID FROM saleItem WHERE quantity = 2)
AND productID NOT IN (SELECT productID FROM saleItem WHERE quantity <> 2)
SELECT DISTINCT productName, listPrice
FROM pr
阅读背景：
为什么这些查询返回不同的结果？
来源：互联网
分享到：
