[Mark Hensler]

(inner) joins combine two tables where a field in table1 match a field in table2. any records that do not have a match, are thrown out of the resulting recordset

left joins include all matches and any orphan records from the left table

right joins appear to do the same but really reverse the table order, then perfom a left join

outer joins include all records

all records that do not have a matching record from the other table will have null values for those fields