select m.mfr_name, b.BROKER_NAME, count( distinct sma.territoryId ) territories
from tblBrokers b
inner join tblMfrBrokerLink mbl
on mbl.BROKER_ID = b.broker_Id
inner join tblManufacturers m
on m.MFR_ID = mbl.mfr_id
left outer join tbl_SMA_BrokerOfficeLink sma
on sma.MFR_ID = m.MFR_ID
and sma.brokerId = b.broker_id
where m.FSEManagedAccess > 0
and m.MFR_ID <> 1984
and b.BROKER_ID <> 1665
and not b.broker_name in ( 'Restaurant Link', 'ABCDEF Company', 'XYZ' )
group by m.mfr_name, b.broker_name
having count( distinct sma.territoryId ) < 1
order by m.mfr_name, b.broker_name
The following Managed Access client manufacturers are listed in the Manufacturer Companies directory of one or more brokers, but those brokers are not listed in the manufacturer's Broker Companies Directories.
| Manufacturer | Broker |
| #htmleditformat( mfr_name )# |
#htmleditformat( broker_name )# |