Aliases: Table Aliases

Table Aliases — Is used to rename a table within a query. This can make queries easier to write and read, especially when dealing with self-joins or complex queries involving multiple tables.

SELECT o.order_id, c.customer_name
FROM orders AS o
JOIN customers AS c ON o.customer_id = c.customer_id;

SELECT column_name(s)
FROM table_name AS alias_name;