How_to_retrieve_data_from_two_or_more_tables_2/demo-queries-from slides-3.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;