---> select distinct mem.email from tbl_CDR_Distributors cdr inner join tbl_FSPRO_Members mem with (nolock) on mem.fspro_userId = cdr.fsl_dstIdBy where mem.email like '%telusagcg.com' order by mem.email select distinct mem.email from tbl_CDR_Distributors cdr inner join tbl_FSPRO_Members mem with (nolock) on mem.fspro_userId = cdr.fsl_dstIdBy where ( mem.email like '%fsenablers.com' or mem.email like '%fslibrary.com' or mem.email like '%blacksmithapplications.com' ) order by mem.email