SQL JOIN Multiple Tables.

select CONCAT(Last_name, CONCAT(' ',First_name)) as Name,
   Telephone_type "Phone type",
   Telephone_number as "Phone number",
   address_type as "Address type",
   us_state_nm as "USA State"
 FROM customers  c
 JOIN telephones t ON (c.Customer_Id=t.Customer_Id)
 JOIN Addresses a ON (c.Customer_Id=a.Customer_Id)
 JOIN US_states u ON (a.US_State_cd=u.US_State_cd)
 where address_type ='Shipping'
 ORDER BY NAME, Telephone_type;

select CONCAT(Last_name, CONCAT(' ',First_name)) as Name,
   Telephone_type "Phone type",
   Telephone_number as "Phone number",
   address_type as "Address type",
   us_state_nm as "USA State"
 FROM customers  c, telephones t, Addresses a ,US_states u
 WHERE c.Customer_Id=t.Customer_Id
 AND c.Customer_Id=a.Customer_Id
 AND a.US_State_cd=u.US_State_cd
 AND address_type ='Shipping'
 ORDER BY NAME, Telephone_type;

select CONCAT(Last_name, CONCAT(' ',First_name)) as Name,
   Telephone_type "Phone type",
   Telephone_number as "Phone number",
   address_type as "Address type",
   us_state_nm as "USA State"
 from customers natural join telephones
               natural join Addresses
               natural join US_states 
 where address_type ='Shipping'
 ORDER BY NAME, Telephone_type;