Posted by Stefan Rybacki on 08/11/05 02:08

Thomas Menzel wrote:
> Hi,
>
> I have two tabels. Table a and table b. Both tables habe a column named x. I
> need a sql statement, wich transfers the colum from a and b in the same
> colum in the resultset.
>
> Example:
>
> table a, column x
> cat
> dog
> duck
> human
>
> table b, column x
> cat
> duck
> bird
>
> result:
> cat
> dog
> duck
> human
> bird
>
>
> Best regards
> Thomas
>
>

You could simply use an UNION DISTINCT.

Regards
Stefan

• Next in forum: Re: writing DB in real time. possible?
• Prev in forum: Re: Create Tabel
• Thread view: Re: Join same columns from two tables

[Reply to this message]