All pastes #750961 Raw Edit

Microsoft query

public sql v1 · immutable
#750961 ·published 2007-10-26 22:38 UTC
rendered paste body
SELECT * FROM Customers3 WHERE (3cstfirst, cstlast, cstphone) NOT IN   (SELECT cstfirst, cstlast, cstphone FROM Customers1)AND cstfirst, cstlast, cstphone NOT IN   SELECT 2cstfirst, cstlast, cstphone FROM Customers2)Fixed the missing (SELECT * FROM Customers3 WHERE (3cstfirst, cstlast, cstphone) NOT IN   (SELECT cstfirst, cstlast, cstphone FROM Customers1)AND 3cstfirst, cstlast, cstphone NOT IN   (SELECT 2cstfirst, cstlast, cstphone FROM Customers2)Now its:SELECT * FROM Customers3 WHERE (3cstfirst, cstlast, cstphone) NOT IN   (SELECT cstfirst, cstlast, cstphone FROM Customers1)AND (3cstfirst, cstlast, cstphone) NOT IN   (SELECT 2cstfirst, cstlast, cstphone FROM Customers2)