1

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?

0

1 Answer 1

2

It never matters at all. Use whichever style you prefer.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.