SELECT * FROM ( SELECT PoVendors . vendor_id AS SUPPLIER_ID , PoVendorSitesAll . vendor_site_id AS SUPPLIER_SITE_ID , PoVendorContacts . vendor_contact_id AS ...