I think it depends on if your table names are readable or not. If you table names are "sales" and "orders" then I would argue that makes the sql a lot more readable i.e
sales.amount
orders.due_date
vs
s.amount
ord.due_date
In the second example I have to flip back and forth between the join statement in order to know where the columns are coming from.
If you have awful table names though like qq123xc then I think aliasing would be appropriate
sales.amount orders.due_date
vs
s.amount ord.due_date
In the second example I have to flip back and forth between the join statement in order to know where the columns are coming from.
If you have awful table names though like qq123xc then I think aliasing would be appropriate