SQL returns "not into" other query

[maikon]

Hi people,

Do exists a way to a query return what doesn't into other query?

For example:

SELECT *
FROM table
WHERE "NOT INTO" (SELECT *
FROM table
WHERE ... )

Someone understood?!

Thanks a lot!

 

[FoFa]

Where MyCol NOT IN (select OtherCol from MyTable)

But Access is not the best performing with this just so you know.

 

[Pat Hartman]

Use the query builder wizard to create an "unmatched" query. It generates a left join and select rows where the key field in tblB is null which is usually more efficient than the subquery.