It sounds like the answer is better data design from the start, so that there's a field to join on in the first place, or two searches and then joining via script