>I can see why you consider this a workaround. :)
>Is record in Other table unique or is a copy of one of the records selected from Reserved table? You do know that UNION internaly does DISTINCT on all result records to eliminate duplicates?
The record is unique. I'll do more research today as this really doesn't make sense.