MySQL Forums
Forum List  »  Newbie

Error 1064
Posted by: Regina Hill
Date: December 09, 2014 09:46PM

I am trying to write a correlated sub-query and keep getting errors. The last error I got was 1064. Here is my code:

SELECT v.vendor_name AS 'Vendor Name'
FROM vendors v
(select i.invoice_id, i.invoice_number, i.invoice_total from invoices i where i.vendor_id = v.vendor_id)
where i.invoice_total > 5000
GROUP BY v.vendor_name;

Options: ReplyQuote


Subject
Written By
Posted
Error 1064
December 09, 2014 09:46PM
December 10, 2014 05:25AM
December 10, 2014 08:12AM
December 10, 2014 08:15AM
December 10, 2014 03:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.