My SQL Tutorials - Joins
The process of forming pairs of rows by matching the contents of related columns is called joining the tables. The resulting table is called a join between the two tables. Joins are the foundation of multi-table query processing. Here is an example of a SELECT statement with a simple JOIN included...
Select Table1.Column1, Column2
Where Column3 equals "Value1"
and Column4 equals "Value2"
and Table1.Column1 = Table2.Column1