Table Aliases
sql
1-- Without alias
2SELECT students.name FROM students INNER JOIN courses ON...
3
4-- With alias (cleaner)
5SELECT s.name FROM students s INNER JOIN courses c ON...Use short meaningful aliases: s, c, o, t
1-- Without alias
2SELECT students.name FROM students INNER JOIN courses ON...
3
4-- With alias (cleaner)
5SELECT s.name FROM students s INNER JOIN courses c ON...Use short meaningful aliases: s, c, o, t