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:
SELECT ...