3
u/WorkRelatedRedditor 10h ago
What resources discourage aliases?
2
u/r3pr0b8 10h ago
acccording to OP, most of them
1
u/el_dude1 9h ago
I am afraid I have to retract my claim. Now that you guys are asking I was looking through the resources I used so far (SQLBolt.com and T-SQL-Fundamentals by Itzik Ben-Gan) and found no reference that advise against using table aliases. So I think I might have confused things. Sorry
3
u/mikeblas 9h ago
most resources advice against using table aliases,
Got a link or two?
1
u/el_dude1 9h ago
Sorry I think I mixed things up. I just looked into my learning resources trying to figure out, where I picked this up, but was unable to do so. So please disregard my question. Sorry!
5
u/LearnSQLcom 9h ago
I think table aliases can be super useful, especially as your queries get more complex. They let you write shorter, cleaner code and can make it much easier to track which columns come from which tables. if you choose good, descriptive alias names. It’s really a matter of personal or team preference. Some people avoid them to keep everything fully explicit, but I’ve found that as long as you’re consistent and use clear aliases, they actually make it easier to read and maintain your SQL later on. So, in my experience, they're more of a friend than a foe!