BorlandTalk.com

Bill Todd · Guest

Try the following:

SELECT PK, FK
FROM DETAIL D LEFT OUTER JOIN MASTER M
ON D.FK = M.PK
WHERE M.PK IS NULL

--
Bill (TeamB)
TeamB cannot answer questions received via email

Terry · Guest

I would like to create a sql select which selects the orphans in a detail
table.
as in
select * from detailtbl
where detailtbl.id not in mastertbl

mastertbl.id is a primarykey
detailtbl.id links many records to one record in mastertbl