How_to_retrieve_data_from_two_or_more_tables/exec_5C64.sql

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