Re: MySQL question

The following should be pretty close:

select users.field1, users.field2
from users
left join blacklist ON users.user_name=blacklist.user_name where blacklist.user_name is null

(field1 etc are the columns you want to select).

And for the Oracle users, mysql may be a little primitive at the moment but is blindingly fast.

gtoomey Received on Sat Oct 19 2002 - 03:41:16 CDT