June 28, 2002 at 9:55 am
Hi
Will the result from queries having the following two formats be different,
format 1.
Select ... From A Left Outer Join B ON A.column1 = B.column1 Left Outer Join C ON
B.column1 = C.column1
format 2
Select ... From A Left Outer Join B Left Outer Join C ON B.column1 = C.column1
ON A.column1 = B.column1
Thx
June 28, 2002 at 10:09 am
yes, you should place the ON after the join clause.
Steve Jones
July 1, 2002 at 12:10 pm
I am trying to find a query which will give different results for these join variations. As you mentioned that the results will be different, do you have any examples to share.
Thx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply