Is it better to compare two recordsets or to have them both in the same query with a Union? Because this made my query a lot slower.

If I were to compare two recordsets (both with "account" as the field I want to compare) and my recordsets are named "COLOC" and "ORDERS" how would I do this?

Thanks