Winn,

JOINs and UNIONs are two totally differen things. Here's how I think of them: a JOIN will get you more columns and sometimes more records, while a UNION always gets you more records but no more columns.

In other words, a JOIN is used to merge together two or more tables into single records. A UNION, on the other hand, is always used to concatenate two or more tables into a single result set. Each JOIN may or may not add records; each UNION always does.

So, after all that, what is it that you're trying to accomplish? :)

>Hi All,
>I was wondering what the 'JOIN' equivelent of the 'UNION' command was.
>Thanks,