The FROM Clause

This is used to specify the table or tables involved in the operation.

If more than one table is involved, then it is a good idea to also specify how the tables are related (joined). Otherwise, the query will produce undesirable effects.

Joining tables can be accomplished in one of two ways:

  1. Using the WHERE clause
  2. Using then INNER JOIN or OUTER JOIN clause