Hi Peter,

Would this work

SELECT file1.* FROM file1 ;
LEFT OUTER JOIN file2 ON file1.id = file2.id ;
WHERE INLIST(file2.ltype, "AA", "BB")


HTH
Mike