How_to_retrieve_data_from_a_single_table/exer_5C11.sql

USE AP;
SELECT vendor_name, customer_last_name, customer_first_name,
       vendor_state AS state, vendor_city AS city
FROM vendors v JOIN om.customers c 
     ON v.vendor_zip_code = c.customer_zip
ORDER BY state, city ASC;