How_to_retrieve_data_from_two_or_more_tables/exer_5C59.sql

USE AP;

DELETE FROM invoice_line_items
WHERE invoice_id IN
(SELECT invoice_id
FROM invoices
WHERE vendor_id = 115)