SQL JOIN type question

Thanks!

"Jochem van Dieten **AdobeCommunityExpert**" <nomail@devnull.invalid> wrote
in message news:eurh7p$qpd$1@forums.macromedia.com...
> Wally Kolcz wrote:
>> If I want to take 2 tables and combine them into one output, which JOIN
>> do I use? Both table's columns have the same name (EMPLOYEE).
>>
>> Table 1 Table2
>> EMPLOYEE EMPLOYEE
>> Emp1 Emp4
>> Emp2 Emp5
>> Emp3 Emp6
>>
>> to get and output of:
>>
>> Emp1
>> Emp2
>> Emp3
>> Emp4
>> Emp5
>> Emp6
>
> You don't need a JOIN, you need a UNION.
>
> Jochem
>
> --
> Jochem van Dieten
> Adobe Community Expert for ColdFusion

Wally Kolcz wrote:
> If I want to take 2 tables and combine them into one output, which JOIN do I
> use? Both table's columns have the same name (EMPLOYEE).
>
> Table 1 Table2
> EMPLOYEE EMPLOYEE
> Emp1 Emp4
> Emp2 Emp5
> Emp3 Emp6
>
> to get and output of:
>
> Emp1
> Emp2
> Emp3
> Emp4
> Emp5
> Emp6

You don't need a JOIN, you need a UNION.

Jochem

--
Jochem van Dieten
Adobe Community Expert for ColdFusion