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.
Short aliases - I tend to use the first letter of each word in the table name - work best, IMO.