[thelist] SQL Query Question

[Means, Eric D]

SELECT this, that, theother
FROM tblFOO
WHERE theother NOT IN ('item1', 'item2', 'item3')

Does that do what you want?

-----Original Message-----
From: Jay Blanchard [mailto:jay.blanchard at niicommunications.com]
Sent: Monday, April 15, 2002 1:01 PM
To: thelist at lists.evolt.org
Subject: [thelist] SQL Query Question


Can this be done?

SELECT this, that, theother
FROM tblFOO
WHERE theother <> to a list of items from tblBAR

I have tried a couple of combinations of things, but cannot get any results
on MySQL 3.2x (no-sub queries allowed). Can this be done without a
sub-query?

TIA!

Jay


--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !