[thelist] SQL Query Question

[Jay Blanchard]

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

Does that do what you want?
[/snip]

Yes, but I don't want to have to change the query for each list item. Since
those items are maintained in another table and can vary from day to day I
want to be able to do this in an automated fashion. If I cannot do it
because of the limitations of MySQL 3.2x (4.x allows sub-queries, but has
not been released as stable yet) I will have to parse the file with the
appropriate constraints (with an AWK script), and import that parsed file
into the db. It would make life so much simpler if I could just parse the
whole file,  import that parsed file into the db and then issue a query.

Jay