ST Alpha - "SQL-masters: Does the order of the "From" tables matter when there are joins?" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 155

SQL-masters: Does the order of the "From" tables matter when there are joins?

Posted by JaxSean (aka JaxSean) Nov 4 '09, 09:08

for example, if I have a query with the following:

From Table1 Left Outer Join
Table2 ON [Table1].id = [Table2].id Left Outer Join
Table3 ON [Table2].id = [Table3].id

would that give different results than say:

From Table2 Left Outer Join
Table3 ON [Table2].id = [Table3].id Left Outer Join
Table1 On [Table1].id = [Table2].id

Responses:

hmmm. the results wouldn't matter, but the efficiency of the execution very well may, depending on how the tables are indexed, esp if there's - prayformojo Nov 4, 09:12 1
- Interesting thought. Thanks. The design view of the SQL Server I used put a query in an 'odd' order to me. - JaxSean Nov 4, 09:32

Post a message top

SQL-masters: Does the order of the "From" tables matter when there are joins?

Replies are disabled on threads older than 7 days.