News for hackers. Stuff that matters.
Re:Best practices for writing SQL queries by barrkel on Saturday April 10, 2021 @04:31PM (#26764863)
Table aliases make queries much less verbose than using the full table name, and more readable as a result. Aliases are unavoidable when you're joining the table more than once. Not using qualified identifiers is just asking for trouble.

Short aliases - I tend to use the first letter of each word in the table name - work best, IMO.

Re:Best practices for writing SQL queries by nickpeterson on Saturday April 10, 2021 @09:37PM (#26766853)
I tend to use two character because you might join similar named tables or the same table multiple times.