table for inner join

  • When I do an inner join of two tables: table 1 and table 2,

    does the postion of the table matters ?

    I mean on the left or right of the inner join, for example

    below, do they make any difference?

    table1 inner join table2

    or

    table2 inner join table1

  • Doesn't matter

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • It'll only matter if you start doing query hint overrides... which you should avoid in 99% of circumstances, so yeah... won't matter. 🙂


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • Thanks!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply