A query join is a permanent relationship between two tables in a query that do not have an established relationship or common field with the same field name and data type.

Question

Quizplus · Accepted Answer

A query join is a temporary relationship created in a query to combine data from two tables based on a related field, not necessarily requiring the same field name or data type.

A Query Join Is a Permanent Relationship Between Two Tables