select dstid as id, dstname as companyname, dstaddr1 as address1, dstaddr2 as address2, dstcity as city, dststate as state, dstzip as zip from tbl_dst_distributors with (nolock) where dstid = select cdr_recordid as id, cdr_dstname as companyname, cdr_dstaddress1 as address1, cdr_dstaddress2 as address2, cdr_dstcity as city, cdr_dststate as state, cdr_dstzip as zip from tbl_CDR_Distributors with (nolock) where cdr_recordid = select cho_id as id, cho_name as companyname, cho_address as address1, cho_address2 as address2, cho_city as city, cho_state as state, cho_zipcode as zip from tbl_cho_operators with (nolock) where cho_id = select operatorID as id, companyName as companyname, address as address1, address2 as address2, city as city, state as state, zipcode as zip from tbl_opr_clientoperators with (nolock) where operatorID = #_companyName#
#_address1#
#_address2#
#_city# #_state#, #_zip#