Re: Error 1064

[Regina Hill]

I did it like this:

SELECT invoice_id, invoice_number, invoice_total,
(SELECT vendor_name
FROM vendors v
WHERE v.vendor_id = i.vendor_id)
FROM invoices i
WHERE invoice_total > 5000
Order by invoice_id;