|
<< Click to Display Table of Contents >> Cartesian join |
  
|
|
<< Click to Display Table of Contents >> Cartesian join |
|
Joins two tables in a non-relational manner.
SELECT *
FROM table_reference, table_reference [,table_reference...]
Use the Cartesian join to join the column of two tables into one result set, but without correlation between the rows from the tables. Cartesian joins match each row of the source table with each row of the joining table. No column comparisons are used, just simple association. If the source table has 10 rows and the joining table has 10, the result set will contain 100 rows as each row from the source table is joined with each row from the joined table.
SELECT *
FROM "Employee.dbf", "Items.db"
