Using aliases simply to shorten your SQL, in my opinion, is a bad practice. It usually means inventing an acronym that no one knows, and it causes them to constantly refer back to the FROM or JOIN clause in which it was introduced to find out the table or view from which it references. For large queries with multiple joins, this can be maddening. Alias are great for SQL statements where you join to the same table more than once.