Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
Given a simple query like this
SELECT *
FROM table_a a
inner join table_b b on b.id_from_a = a.id
Does the order of the on clause matters? In the example above I always put the recently joined table on the left side of the equal sign and on the right side I put the first table
Would
SELECT *
FROM table_a a
inner join table_b b on a.id = b.id_from_a
perform the same way?
It never matters at all. Use whichever style you prefer.
