[EMAIL PROTECTED] schreef: > SELECT EMPNO FROM EMP WHERE EMPNO NOT IN ( SELECT EMPNO > FROM [EMAIL PROTECTED] )
Or maybe use something like select EMPNO as E1 from EMP left join [EMAIL PROTECTED] as E2 on E1.EMPNO = E2.EMPNO where E2.EMPNO IS NULL (untested) > So search FILE1 for all line entries of FILE2 then output whoever > does not exist Look into `sort` and `diff` and `uniq -u`. -- Affijn, Ruud "Gewoon is een tijger." -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>