Answer: Does the join order matter in SQL?

answer re: Does the join order matter in SQL?

Mar 8 '12

228

For INNER joins, no, the order doesn't matter. The queries will return same results, as long as you change your selects from SELECT * to SELECT a.*, b.*, c.*.

---

For (LEFT, RIGHT or FULL) OUTER joins, yes, the order matters - and (updated) things…

</p>

Open Full Answer

Order of joins matter