Phone No used to register in Multiple organizations.
SELECT distinct l.PhoneNo FROM MemberPortal_Bulk l
INNER JOIN(
SELECT OrgID, PhoneNo,count(*) Noof
FROM MemberPortal_Bulk group by OrgID, PhoneNo
having count(*)>1) noof on l.PhoneNo=noof.PhoneNo
where l.OrgID!=noof.OrgID
No comments:
Post a Comment