It enforces foreign keys during select.
One can say that it makes you explicitly state, which foreign key do you use.
"on a.foo = b.bar" can be a incomplete and/or incorrect join condition.
One can say that it makes you explicitly state, which foreign key do you use.
"on a.foo = b.bar" can be a incomplete and/or incorrect join condition.