![]() |
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
21 Dec 2013
| 4 comments
,
|
![]() |
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:
25 Jun 2013
| 1 comment
,
|