>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? :)
Chuck,
I am trying to put two tables together, 'head-to-tail'. I guess I will keep my union the way it is.
Thanks,
Winn Pauley