Glossary: SQL Beyond the Basics
Alias
Also written: aliases, AS
A short name given to a table or column inside a query, such as `orders AS o`. Putting the alias before column names avoids 'ambiguous column name' errors when joined tables share a column name.