| Subject | Re: [ib-support] insert and select with Union |
|---|---|
| Author | Doug Chamberlin |
| Post date | 2002-12-29T00:49:03Z |
At 12/28/2002 06:37 PM (Saturday), Marco Menardi <mmenaz@...> wrote:
insert into mytable (x,y,z)
select a, b, c
from Atable;
insert into mytable (x,y,z)
select a, b, c
from Btable;
>insert into mytable (x,y,z)What is the reason you do not perform two separate INSERT statements? Try
>select a, b, c
>from Atable
>UNION
>select a, b, c
>from Btable
insert into mytable (x,y,z)
select a, b, c
from Atable;
insert into mytable (x,y,z)
select a, b, c
from Btable;