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.