Re: Simple SQL question

try a solution with a subquery:

SELECT * FROM user_table WHERE user NOT IN

        (SELECT user FROM user_level_table)

Carsten Busch
Geographisches Institut FSU Jena
email: ncb_at_geogr.uni-jena.de

!!!!!New Phone and Fax Number !!!!!!
Tel:03641-9-48866 Fax:03641-9-48852

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!