Hi Folks,
I need to be clear about what exactly difference when we put any condition in INNER JOIN and WHERE Clause.
I tried both way and found same results. Even in Statistics Plan not much differences. All Help would be appreciated.
Like:
1. Here I am using location filter in Inner join condition -
"SELECT I.*, Gl * From Sc1.Item I
Inner Join Sc1.Part P
On P.Part_Id = I.Part_Id
Inner Join Sc1.Location Gl
On Gl.Location_Id = I.Location_Id
And Gl.Location_Id In ( 1767, 1747,202,1625)
Inner Join Sc1.Condition C
On C.Condtion_Id = Gl.Condition_Id
Where I.Inactive_Ind = 0
And I.Condition_Id != 325
2. Here I am using location filter in Where clause -
SELECT I.*, Gl * From Sc1.Item I
Inner Join Sc1.Part P
On P.Part_Id = I.Part_Id
Inner Join Sc1.Location Gl
On Gl.Location_Id = I.Location_Id
Inner Join Sc1.Condition C
On C.Condtion_Id = Gl.Condition_Id
Where I.Inactive_Ind = 0
and I.LOCATION_ID in ( 1767, 1747,202,1625)
And I.Condition_Id != 325
Thanks,
Mark