Priority of " left jion" and "and"
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
Regards,
Jason
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
0