4 ms·
It's pretty annoying to do joins and have to alias all your columns because their names are ambiguous. Also in my experience most people use very terse table a
by itsdrewmiller 9y ago
It's pretty annoying to do joins and have to alias all your columns because their names are ambiguous. Also in my experience most people use very terse table aliases so it's not always obvious what "u.ID" "uc.ID" "puc.ID" etc. are referring to.
- combatentropy 9y agoYou don't need to alias "all" of your columns, just about 1 out of 10. And I don't understand the complaint about terse table aliases being non-obvious. The answer key is right below the select clause.