SELECT [SomeField] FROM Table1
WHERE Table1.[SomeField]
NOT IN (SELECT [SomeField] FROM Table2)
--
_________
Sean Bailey
"gmazza via AccessMonster.com" wrote:
> Hey there,
> How can I make a query to Select data from one table that doesn't exist in
> another table.
> For example, I have 2 tables.
> Table 1 - Trademark
> Data: 1 2 3
>
> Table 2 - Competitor
> Data 1 2
>
> So on my Competitor form, I have a combo box and I want to only see the
> values from Trademark that aren't already in Competitor. I want my query to
> return 3.
>
> Obviously there is more going on, just wanted to give a quick rendition of
> what I need, hope it makes sense.
> Thanks!
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...oding/200907/1
>
>
Similar Threads
