Hi,

It seems that Firebird doesn't support UNION in INSERT queries. Is this
by design or is it a bug? If it's by design will it be supported in 2.0?

insert into "TargetTable" (...)
select ...
from ...
union
select ...
from ...

It works if I remove the insert clause and just do the select(s).

Thanks,
Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64