Combining recordsets

Sometimes, you will find that you have obtained recordsets that are not exactly what you need. This recipe shows various ways of combining them.

Getting ready

To use this recipe, you need to have two or more recordsets for the same model.

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...