SQL Language (MOSC)

MOSC Banner

Priority of " left jion" and "and"

edited May 30, 2012 7:17PM in SQL Language (MOSC) 4 commentsAnswered
Experts,
          the sql is normal on 10g, however, error on 11.2, why?
          the SQL as following:
-----------------------------------------------------------------------------------------------------------------------
    left join proposal_car@toesalesdb p on p.sales_no = t.sales_no    

      left join cust_info@toesalesdb c on c.cust_id = t.cust_id and c.cust_id like 'N%'

      left join rep.StatDCompanyLevel w on w.comcode = t.coreunitid


-----------------------------------------------------------------------------------------------------------------------

Regards,
Jason

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center