select m.mfr_id
from tbl_bro_principals p with (nolock)
inner join tblManufacturers m with (nolock)
on m.mfr_id = p.mfrid
where p.principalid in ()
and p.ownerid =
and p.ownertype =
order by m.mfr_name
Stocking Status
#qcfAccountDetails.cdr_dstname#
#qcfAccountDetails.cdr_dstaddress1#
#qcfAccountDetails.cdr_dstaddress2#
#qcfAccountDetails.cdr_dstcity# #trim(qcfAccountDetails.cdr_dststate)#, #qcfAccountDetails.cdr_dstzip#