select mfrid, mfr_name from qryMfrList where mfrid in () order by mfr_name select distinct mfr.mfr_id, mfr.mfr_name, mfr.mfrabbrev_name from tblManufacturers mfr inner join tblMfrBrokerLink mbl on mbl.MFR_ID = mfr.MFR_ID and mbl.BROKER_OFFICE_ID = inner join tbl_SMA_BrokerOfficeLink bol on bol.MFR_ID = mbl.mfr_id and bol.BrokerOfficeID = where mfr.mfr_id in () and exists (select * from tbl_PRD_SKUs where OwnerID = mfr.MFR_ID and FSL_TableCode = 'mfr') order by mfr.MFR_NAME