[thelist] SQL Query Question

[Jay Blanchard]

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