/ Published in: SQL
Reemplaza el NOT IN
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
SELECT c.CustomerID FROM Sales.Customer AS c LEFT OUTER JOIN Sales.SalesOrderHeaderEnlarged AS h ON c.CustomerID = h.CustomerID WHERE h.CustomerID IS NULL;