SELECT * From ChildTable WHERE ChildTable.FK NOT IN ( ; SELECT ParentTable.PK from ParentTable) or SELECT * From ChildTable WHERE NOT EXISTS ( ; SELECT ParentTable.PK from ParentTable ; WHERE ParentTable.PK = ChildTable.FK ) or SELECT ChildTable.* From ChildTable ; RIGHT OUTER JOIN ParentTable ON ChildTable.FK = ParentTable.PK ; AND ISNULL(ParentTable.PK)The quickest
SELE * From ChildTable WHER FK NOT IN ( ; SELE PK from ParentTable)>Hi