>Hilmar,
>Thank you for answering my question. The fact that there is no way to do what is necessary with a join is what I needed to know. I just thought I would see if there was a better way.
>Thanks,
Well, if what you want to do is join records "vertically", the only pure SQL option seems to be the UNION, which you already know.
Other alternatives (non-SQL) include APPEND FROM, and copying records in a loop (SCATTER NAME).
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)