Deleting primary records in one-to-many relationship

[skhanal]

select ApplicantID
from tblApplicants
where ApplicantID
not in
(select ApplicantID from tblApplications)

this will give you all applicantID. Or you could generate a script as

select 'delete tblApplicants where ApplicantID = ' + cast(ApplicantID as varchar(20)
from tblApplicants
where ApplicantID
not in
(select ApplicantID from tblApplications)