123456 |
- 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;
|