OK, so specifically it would be SELECT stuff FROM whereever WHERE NOT EXISTS (SELECT 'X' FROM interview_tables WHERE whereever.EMPLID=interview_tables.EMPLID). _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users