1.Records from the second recordset and only records from the first recordset where the common fields are equal
2. Records from the first recordset and only records from the second recordset where the common fields are equal
3.Records that have the same value in the common field
4.Records from the first recordset only