SELECT * FROM ( SELECT broker_name AS CompanyName, Broker_ID AS OwnerID, 'BRO' AS OwnerType, 'Broker' AS companyType FROM tblBrokers WHERE Broker_Name LIKE UNION SELECT MFR_Name as CompanyName, mfr_ID as OwnerID, 'MFR' AS ownerType, 'Manufacturer' AS companyType FROM tblManufacturers WHERE MFR_Name LIKE UNION SELECT Company as companyname, UserID as OwnerID, 'MISC' as OwnerType, 'Miscellaneous' AS companyType FROM tbl_MSC_FSLibraryUsers WHERE Company LIKE ) AS x ORDER BY OwnerType, CompanyName

Company Name:
MAXIMUM OF 500 RECORDS RETURNED OwnerID OwnerType Company Name #qry_userlookup.companyType# #qry_userlookup.OwnerID# #qry_userlookup.OwnerType# #qry_userlookup.CompanyName#