select mfr.mfr_id, mfr.mfr_name, mfr.mfrabbrev_name from tblManufacturers mfr where mfr.mfr_id in () order by mfr.MFR_NAME select mfr.mfr_id, mfr.mfr_name, mfr.mfrabbrev_name from tblManufacturers mfr where mfr.mfr_id in () order by mfr.MFR_NAME select mfrid, mfr_name from qryUserMfrs 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 in (select broker_office_id from tblBrokerOffices where BROKER_ID = ) inner join tbl_SMA_BrokerOfficeLink bol on bol.MFR_ID = mbl.mfr_id inner join tbl_ORG_AttributeLinks oal on oal.mstr_attrTypeID = 34 and oal.mstr_attrID = and oal.child_attrTypeID = 27 and oal.child_attrID = 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 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 in (select broker_office_id from tblBrokerOffices where BROKER_ID = ) order by mfr_name