Hi,

> >Is there som way to user a union in an insert clausule?
>
> No; because an insert applies a single input row to a single insert
> row. Any union is implicitly two or more rows.

Does it?

This is valid:
INSERT INTO ... SELECT ...

> >I just can´t use a View instead.
>
> Why not?
>
> And, if not, then you'll need to write a selectable stored procedure to
> pump the output of a union into a table <shudder>

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com