Re: select from a list where not in a table

"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
|

you've answered your own question :

| I am trying to select from a list of ids where the ids are --->>not
in<<---

you'll see that you've described your problem with the operator that you need to use

also, temporary tables are infrequently used in solving problems -- they are somewhat of a last resort. usually there is an efficient and relatively straight-forward way to solve the problem using SQL syntax, often using a subquery (another hint for your situation)

++ mcs Received on Mon Dec 13 2004 - 18:59:23 CST