sql version of "is not among"?

psychomachine · #1 (**permalink**) 03-01-04, 09:52

What would be the correct sql syntax for a query along these lines:

select * from table1 where table1.id IS NOT AMONG table2.particularcolumn

sorry, i really got stuck.

vanekl · #2 (**permalink**) 03-01-04, 11:23

select * FROM table1 LEFT JOIN table2 USING (particularcolumn)
WHERE table1.particularcolumn IS NULL;

vanekl · #3 (**permalink**) 03-01-04, 11:24

my bad. should read,

select * FROM table1 LEFT JOIN table2 USING (particularcolumn)
WHERE table2.particularcolumn IS NULL;

psychomachine · #4 (**permalink**) 03-01-04, 12:04

great!!! many thanks

Internet Services

Web Development

Digital Marketing

Consumer Tech