Dear all,

I would like to know, How to do in Criteria

select psr.Profile_MasterID, pel.ECP_MasterID, psr.MobileNumber
from dbo.PatientSearchResult psr
left join (Select * from Profile_ECP_Linkage
Where ECP_MasterID != @Logged_ECP_ID) pel on
psr.Profile_MasterID = pel.Profile_MasterID
where pel.Id is null


Note : @Logged_ECP_ID is from user defined Id


Thank you,

Regards and Meeta,
Ichirohang

What does your mapping look like?