If I have table 1 -------------------- user job -------------------- joe manager sam Staff harry manager
and a query that returns -------------------- user job -------------------- joe manager harry manager dick staff is there a way to get this (i.e. anyone in table1 that don't have matching rows in the query) in SQL ---------------- User job ---------------- Sam staff Thanks Justin -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
