0 - 2 of 2 tags for outer join

Hi, I have a doubt when coding ON and WHERE clause for Joins (Inner Vs Outer).


I think, for an Inner Join its does not make a difference whether we apply the condition with ON cluase or WHERE cluase.


Please refer the 2 queries belows-


sel customer_id,customer_name,order_amount

Hi all,

I'm having some performance issues due to the way certain queries are being processed by the optimizer. I have a set of views that I want to join together, and each of these views has the same JOIN/WHERE clause combination: