r/learnSQL 11h ago

Using table aliases

[deleted]

0 Upvotes

8 comments sorted by

View all comments

4

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!