User Profile

Collapse

Profile Sidebar

Collapse
radmanmm
radmanmm
Last Activity: Jan 31 '08, 12:47 AM
Joined: Sep 26 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • radmanmm
    replied to importance of order in the ON statement
    in SQL Server
    So are you saying that the position of the tables are important specifically in the On statement?

    table1.id = table2.id as opposed to table2.id = table1.id....
    See more | Go to post

      Leave a comment:

    • radmanmm
      started a topic importance of order in the ON statement
      in SQL Server

      importance of order in the ON statement

      Hello All,

      I have had a question come up and was wondering if anyone knew the answer. Given the following query:

      Select * From Table1 Left Outer Join Table2 On Table1.Id = Table2.Id

      Is there any difference if the On statement was switched? Such as:

      Select * From Table1 Left Outer Join Table2 On Table2.Id = Table1.Id

      Thanks
      See more | Go to post
      No activity results to display
      Show More
      Working...