[SQL ] 新手请教EXISTS语法问题

楼主: neweom (新哥)   2019-05-12 00:02:36
在w3schools这题 https://bit.ly/2D7WLmn 范例中
SELECT SupplierName
FROM Suppliers
WHERE EXISTS (SELECT ProductName FROM Products
WHERE Products.SupplierID = Suppliers.supplierID AND Price < 20);
会得到 24 个 SupplierName的结果
但是如果我改写成
SELECT SupplierName
FROM Suppliers
WHERE EXISTS (SELECT ProductName FROM Products,suppliers
WHERE Products.SupplierID = Suppliers.supplierID AND Price < 20);
会得到 29 个 SupplierName的结果
多出来的五笔资料Price都 > 20
不知道两个SQL语法的差别在哪里,恳请大大指导
作者: awwseed (MOTO RIDER)   2019-05-30 13:28:00
为什么 EXISTS 里面的 FROM 要多 ,suppliers ?

Links booklink

Contact Us: admin [ a t ] ucptt.com