# 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.

```sql
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](https://www.ask-codey.com/glossary?category=sql&level=3)

Updated: November 9, 2026

## In other subjects

- [Alias in PowerShell](https://www.ask-codey.com/glossary/alias-powershell)
- [alias in Unix](https://www.ask-codey.com/glossary/alias-unix)

Source: https://www.ask-codey.com/glossary/alias
