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 publishersWHERE NOT EXISTS (SELECT * FROM titles WHERE pub_id = publishers.pub_id AND type = 'business')ORDER BY pub_name 阅读全文
posted @ 2014-03-14 11:07 loveking_阳 阅读(205) 评论(0) 推荐(0) 编辑
