I believe this is what foreign keys are for, and also, they are usually both int...

jessaustin · on April 8, 2016

With aliases that first expression might be:

  c.id = p.id

That seems like an easy error to make...

liotier · on April 8, 2016

> With aliases that first expression might be: c.id = p.id

Which is why I don't use aliases, so that future me doesn't have to wonder what the hell he wrote a few months ago.

rlucas · on April 8, 2016

Once an application has been alive for more than a few months, I find it often is subject to self-joins and other query approaches which pretty much beg for aliases in the name of legibility.

dsp1234 · on April 8, 2016

subject to self-joins and other query approaches

Which means that the original argument about reserveration_id vs id doesn't matter since it's likely that both table and column aliases would be needed anyways.