select mfr_id, rtrim( m.mfr_name ) mfr_name
from tblManufacturers m
where m.mfr_id not in (
select cmp.mfrId
FROM tbl_BRO_PrincipalCompetitors cmp
inner join tblManufacturers m
on m.mfr_id = cmp.mfrId
inner join tbl_BRO_Principals ppl
on ppl.principalId = cmp.principalId
and ppl.ownerId = cmp.ownerId
and ppl.ownerType = cmp.ownerType
where cmp.ownerid =
and cmp.ownerType =
and ppl.mfrId =
)
and m.mfr_id <>
and m.crmActive = 'Y'
and m.parentMfrId is null
order by m.mfr_name
SELECT mfr_id, mfr_name from qmd_manufacturerSearch
WHERE mfr_id NOT IN ( )