select dstparentCo, dstId from tbl_DST_Distributors dst with (nolock) inner join tbl_CDR_Distributors cdr with (nolock) on cdr.fsl_dstId = dst.dstId where cdr.cdr_recordId = #_dateRangeFieldsHTML#