Alias

An Alias is an alternate (usually short) name assigned to a table to make it easier to…

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

Level: Journeyman · More SQL terms at this level

Updated