Joins in Oracle: Which field on which side of an = sign? Joins in Oracle: Which field on which side of an = sign? oracle oracle

Joins in Oracle: Which field on which side of an = sign?


It makes no difference. The only time the order matters is when you are doing LEFT and RIGHT OUTER joins, but those keywords all fall before the ON keyword.


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.