Nothing is more satisfying than doing the impossible. Often we are asked to find a way to create a query in Raiser’s Edge when either the records don’t have anything in common, or when the only thing they have in common is a field that is not available to select in the Query module.
The screencast below shows how you can “trick” the database into building a query for you by going out and back-in through the easiest import ever. Video is 9 minutes, but once you get the hang of this trick, you can set it up in 5 minutes and save yourself tons of time.
Best watched in full-screen mode — just click the four arrows in the bottom-right of video controller bar.