SQL allows you to use an alias in place of a table name in some queries. In the following query, alias “a” is used for the accounts table and “c” for the customers table.
SELECT name, balance FROM customers c, accounts a WHERE a.customer_id = c.id;
The alias is defined in the FROM clause and then used in the WHERE clause.