table alias

A short name given to a table inside one query, such as c for customers, used to qualify its columns.

In more detail

Write it after the table name in FROM or JOIN, optionally with AS. Aliases are required when the same table appears twice, such as employees joined to their managers, and make every join easier to read.

Example

FROM order_items AS oi JOIN products AS p ON p.id = oi.product_id

Related terms

Taught in

References