WillyVervest
/
How_to_retrieve_data_from_two_or_more_tables_2
forked from bdelepeleer/How_to_retrieve_data_from_two_or_more_tables
Watch 1
Star 0
Fork 0
Code Issues 0 Pull Requests 0 Releases 0 Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
13 Commits
1 Branch
Branch: master
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
How_to_retrieve_data_from_t.../exercise-5.sql

exercise-5.sql 314B
Raw Permalink Blame History

1234567 
  1. SELECT v1.vendor_id, 

  2.        v1.vendor_name,

  3.        CONCAT(v1.vendor_contact_first_name, ' ', v1.vendor_contact_last_name) AS contact_name

  4. FROM vendors v1 JOIN vendors v2

  5.     ON v1.vendor_id <> v2.vendor_id AND

  6.        v1.vendor_contact_last_name = v2.vendor_contact_last_name  

  7. ORDER BY v1.vendor_contact_last_name