>Sounds like query with EXCEPT > >May be you can get it using > >WHERE > RecID NOT IN > (select A.RecID FROM T1, T2 WHERE T1.id = T2.ptr ) >And > RecID NOT IN > (select A.RecID FROM T1, T3 WHERE T1.id = T3.ptr ) > >Not sure how effective this will be. > Thanks a bunch, Ruslan. It works.