How_to_retrieve_data_from_two_or_more_tables/exec_5C37.sql

USE AP;

SELECT invoice_number, invoice_date, invoice_total
FROM invoices
WHERE vendor_id IN
    (SELECT vendor_id
    FROM vendors
    WHERE vendor_state = 'CA')
    ORDER BY invoice_date;