HomeActive Query Builderhelp excluding results from query

help excluding results from query


I am new to this so please bear with me.

I have multiple queries that connected with a Union. Those queries give me the result that I want. Now I want a query that gives me all records in a table that aren't in those queries. How do I accomplish that?

Thanks in advance.
Big T | email
November 5 2009, 11:08 AM
SELECT * FROM Table WHERE Id NOT IN (<your select query with unions>)
Sergey Smagin | email
15 hours, 13 mins since original post
Thanks for the reply. That seems like that should work, but I must have something not right. I am getting the following error:

Only one expression can be specified in the select list when the subquery is not introduced with
EXISTS.

I have tried putting "EXISTS" in a couple different places & that just causes more problems.
Big T | email
21 hours, 46 mins since original post
Nevermind. I got it figured out. Thanks!
Big T | email
22 hours since original post
This topic is closed