Re:SQL style guide
by webbore on Sunday October 09, 2016 @02:50PM
(#12672713)
ON second reading I think you are correct. I agree on this point then, as it helps when joining through a denormalized table that references multiple PK ids, ex: I think:
user_id = role_id
is more readable than the likely alternative:
u.id = r.id
[ Parent
| on HN ]
Re:SQL style guide
by NickNameNick on Monday October 10, 2016 @01:32AM
(#12675249)
it also lets you use the
join foo using(foo_id)
syntax, which I quite like