Sullivan Market

a web based full-circle development system

My SQL Tutorials - Joins

Simple 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
From Table1,
Where Column3 equals "Value1"
and Column4 equals "Value2"
and Table1.Column1 = Table2.Column1

Back To SQL Tutorials