DEV Community

loading...

Answer: Does the join order matter in SQL?

boyukbas profile image baris ・1 min read

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>





Order of joins matter

Discussion (0)

pic
Editor guide