Query returns all primary_vendor_no (as vendor_locations) which exist in all three companies results: vendor_locations 123
Here's the query
select primary_vendor_no, count(primary_vendor_no) as vendor_locations from ( SELECT distinct primary_vendor_no, company_code FROM combined_item_master group by primary_vendor_no, company_code ) as a
group by primary_vendor_no having count(primary_vendor_no)=3 order by vendor_locations DESC, primary_vendor_no