SQL allows you to use an alias in place of a table name in some queries. In the following query, the alias a is used for the accounts table and the alias 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.