SQL: ... WHERE X IN (SELECT Y FROM ...) ...
- by Craig Johnston
Is the following the most efficient in SQL to achieve its result:
SELECT * FROM Customers WHERE Customer_ID NOT IN (SELECT Cust_ID FROM SUBSCRIBERS)
Could some use of joins be better and achieve the same result?