Sometimes, you will find that you have obtained recordsets which are not exactly what you need. This recipe shows various ways of combining them.
Here is the way to achieve common operations on recordsets:
To merge two recordsets into one while preserving their order, use the following operation:
result = recordset1 + recordset2
To merge two recordsets into one ensuring that there are no duplicates in the result, use the following operation:
result = recordset1 | recordset2
To find the records that are common to two recordsets, use the following operation:
result = recordset1 & recordset2