LEFT JOIN ... ON (...) - missing keyword?
When I try to run this query:
select *
from affiliates a
join vendors v
left join affiliate_vendors av on (av.affiliateid = a.affiliateid and av.vendor = v.vendor)
I get a "missing keyword" error.
The table affiliate_vendors in an intersection table between affiliates (primary key affiliateid) and vendors (primary key vendor). The primary key of affilaite_vendors is the pair (affiliateid, vendor)
What is Oracle expecting?