Need help with LEFT JOIN Query
Well, I have a query like this:
But this shows below error:
SELECT *,ba.areaName AS areaName2 from vendor v, subscriptions s, areas a
LEFT JOIN areas AS ba ON v.areaID2 = ba.areaID
WHERE s.subsID = v.subsID AND a.aid = v.areaID AND v.vendorDel = '0'
Please help me what is the FIX to this error, because, in table vendor, column areaID2 is present.
There is some error in select query in table :vendor v, subscriptions s, areas a Unknown column 'v.areaID2' in 'on clause'
Thanks a multi billion !