An outer join selects all the records from one table and only those records in the second table that have matching values in the joined field. A left outer join selects all records from the table on the left and only those records from the table on the right that have matching values in both tables. A right outer join selects all records from the table on the right and only those records from the table on the left that have matching values in both tables.
Негізгі бет Creating Left Outer and Right Outer Joins in MS Access - Office 365
No video
Пікірлер: 7