Unlike criteria, joins also specify that each pair of rows that satisfy the join conditions will be combined in the recordset to form a single row.

• 与条件不同的是,联接还指定满足联接条件的每两行将在记录集中合并成一行。