Using the Relational Data Framework › Join Operations

Join Operations

SELECT statements can search for data stored in more than one relational table. Selecting data from more than one table is called a join operation; it produces a new temporary table containing all rows and columns of all tables referenced in the SELECT statement. This temporary table remains in memory only until the SELECT statement finishes executing.

The following section discusses comparing values from multiple tables, and defining aliases or correlation values for table names.