News for hackers. Stuff that matters.
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
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