SELECT vendor_id,
       concat(vendor_contact_first_name, vendor_contact_last_name) AS contact_name 
FROM vendor_contacts v JOIN vendor_contacts v1
	ON v.vendor_id <> v1.vendors_id v1
	AND v.vendor_contact_last_name = v1.vendor_contact_last_name
ORDER BY v.vendor_contact_last_name ASC;