ABSTRACT
There is often a need to select data from columns from more than one table. A join combines columns and data from two or more tables (and in some cases, of one table with itself). The tables are listed in a FROM clause of a SELECT statement, and a join condition between the two tables is specified in a WHERE clause.
