Alias
noun
say it: “AY-lee-us” /ˈeɪliəs/
A short name given to a table in a query, such as o for Orders, so columns can be written o.OrderID.
What is an Alias?
An Alias is an alternate (usually short) name assigned to a table to make it easier to differentiate between tables. This is commonly done when joining 2 or more tables.
SELECT c.CustomerName
, o.OrderDate
, o.OrderId
FROM Customers AS c
INNER JOIN Orders AS o
ON c.CustomerId = o.CustomerId
In a sentence
- “With the alias c for Customers, the join reads c.CompanyName.”
Level: Journeyman · More SQL terms at this level
Updated