Re: select from a list where not in a table

From: Alan <alan_at_erols.com>
Date: Mon, 13 Dec 2004 13:00:08 -0500
Message-ID: <3263lpF3g1e3jU1@individual.net>

"dmclaude" <dmclaude_at_yahoo.com> wrote in message news:1102960407.741523.19690_at_f14g2000cwb.googlegroups.com...
> All,
>
> I am trying to select from a list of ids where the ids are not in a
> table. So far all I've come up with is adding all the ids to a
> temporary table and then selecting from one where not in the other.
>
> Is there an easy (no table creation) way to do this?
>
> eg. (in pseudo code)
>
> Table Test
> id varchar (2)
> {'aa', 'cc', 'dd')
>
> List testList
> ('aa', 'bb')
>
> I want to be able to see 'bb' is in list testList but not in table
> Test.
>
> appreciate any help
> -dmclaude
>

Look up WHERE...IN Received on Mon Dec 13 2004 - 12:00:08 CST