what is join order in sql

Question

Does join order is determined on mention of table in sequence or on the order of tables in 'on' clause?

Is

select *
  from A 
  left 
  join B 
    on A.id=B.id

same as

select * 
  from A 
  left 
  join B 
    on B.id = A.id

?

Yes, the order is determined by which table is 'operand' of JOIN clause only. — raina77ow, Jan 10 '18 at 08:11
I chose to mark as duplicate because the accepted answers are probably nicer and more helpful than anything you would receive here. If you are really stuck on something, drop a note and someone can reopen the question. — Tim Biegeleisen, Jan 10 '18 at 08:14

score 1 · Answer 1 · answered Jan 10 '18 at 08:13

1

Yes, although I prefer the second option. It sounds more like natural language to my ear.

answered Jan 10 '18 at 08:13

Strawberry

score 0 · Answer 2 · answered Jan 10 '18 at 08:14

0

They are the same. The logical conditions are commutative. Read here for more insights on MySQL joins.

answered Jan 10 '18 at 08:14

cdaiga

2 Answers2