Hi guys,

Here is the question:
If we have table t1 and t2 having exact the same columns.
And we want to create a new table t3, whose content is the combine
(union) of the content of t1 and t2, how can we write the sql?

I tried:
create table t3 (select * from t1, t2);
create table t3 (select * from t1 union all select * from t2);

Both are not working. :-(
Any ideas?

Thanks.

On 23 Jul, 03:22, Kevin <happy_singap...@yahoo.com.sg> wrote:
> Hi guys,
>
> Here is the question:
> If we have table t1 and t2 having exact the same columns.
> And we want to create a new table t3, whose content is the combine
> (union) of the content of t1 and t2, how can we write the sql?
>
> I tried:
> create table t3 (select * from t1, t2);
> create table t3 (select * from t1 union all select * from t2);
>
> Both are not working. :-(
> Any ideas?
>
> Thanks.

Sorry my crystal ball appears to be faulty. Look as I might I just
can't see in what way the 2 queries are not working!

Maybe you could tell us!