select b.BROKER_NAME, m.MFR_NAME, count( distinct mbl.broker_office_id ) offices
from tblManufacturers m
inner join tbl_SMA_BrokerOfficeLink sma
on sma.MFR_ID = m.MFR_ID
inner join tblBrokers b
on b.BROKER_ID = sma.brokerid
left outer join tblMfrBrokerLink mbl
on mbl.BROKER_ID = sma.brokerId
and mbl.mfr_id = m.mfr_id
where m.FSEManagedAccess > 0
and m.MFR_ID <> 1984
and b.BROKER_ID <> 1665
group by b.broker_name, m.MFR_NAME
having count( distinct mbl.broker_office_id ) < 1
order by b.broker_name, m.mfr_name
The following brokers are in one or more Managed Access client manufacturer's Broker Company directories, but are not listed in the broker's Manufacturer Companies directories.
| Broker | Manufacturer |
| #htmleditformat( broker_name )# |
#htmleditformat( mfr_name )# |