Re: Error 1064
Surely you just need a join?
SELECT v.vendor_name AS 'Vendor Name'
,i.invoice_id
,i.invoice_number
, i.invoice_total
FROM vendors v
JOIN invoice i
ON i.vendor_id = v.vendor_id
where i.invoice_total > 5000
;
Good luck,
Barry.
Subject
Written By
Posted
December 09, 2014 09:46PM
Re: Error 1064
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.