>>Hi All,
>>I was wondering what the 'JOIN' equivelent of the 'UNION' command was.
>>Thanks,
>
>There is none. These clauses have completely different functions. JOIN is used to combine records from different tables. "horizontally" - UNION, to combine groups of records "vertically".
>
>Hilmar.

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,