select m.mfr_id, m.mfr_name, img.imageIcon
from tblManufacturers m
left outer join qryImageFullPathLookup img
on img.ImageID = m.MfrCompanyLogo
where exists (
select * from tbl_BRO_Principals where mfrId = mfr_id and ownerId = 14
)
order by m.mfr_name