solidDB Help : Programming : Getting started with SQL : Creating tables with related data : Table aliases
  
Table aliases
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.
Go up to
Creating tables with related data