How to do it...

Here's the way to achieve common operations on recordsets:

1. To merge two recordsets into one while preserving their order, use the following operation:

result = recordset1 + recordset2 

2. To merge two recordsets into one while ensuring that there are no duplicates in the result, use the following operation:

result = recordset1 | recordset2 

3. To find the records that are common to two recordsets, use the following operation:

result = recordset1 & recordset2