select distinct mem.email from tbl_OPR_ClientOperators opr inner join tbl_FSPRO_Members mem with (nolock) on mem.fspro_userId = opr.fsl_choIdBy where mem.email like '%telusagcg.com' and mem.email = order by mem.email select distinct mem.email from tbl_OPR_ClientOperators opr inner join tbl_FSPRO_Members mem with (nolock) on mem.fspro_userId = opr.fsl_choIdBy where ( mem.email like '%fsenablers.com' or mem.email like '%fslibrary.com' or mem.email like '%blacksmithapplications.com' ) and mem.email = order by mem.email