When two tables in a query share no common fields, each record in one table connects to each record in the other table, creating a(n) _____.
A)many-to-many relationship
B)one-to-one relationship
C)outer join
D)Cartesian join

Question

Quizplus · Accepted Answer

When two tables in a query share no common fields and each record in one table connects to each record in the other table, it creates a Cartesian join, also known as a Cartesian product. This results in a table that combines every row from the first table with every row from the second table.

When Two Tables in a Query Share No Common Fields