The =
operator is symmetric, so a.id = b.id
is exactly the same as b.id = a.id
. Personally, I prefer having the fields from the driving table (the one in the FROM
clause) on the left hand side of the operator, but that's purely an aesthetic preference.