Mysql EXISTS NOT EXISTS

SELECT c.CustomerId, CompanyName  
	FROM Customers c  
	WHERE EXISTS(  
	    SELECT OrderID FROM Orders o  
	    WHERE o.CustomerID = cu.CustomerID
	)



SELECT pub_name FROM publishers
WHERE NOT EXISTS (SELECT * FROM titles
    WHERE pub_id = publishers.pub_id
    AND type = 'business')
ORDER BY pub_name

  

原文地址:https://www.cnblogs.com/lovekingly/p/3600098.html