Hi Helen,

>
> No; because an insert applies a single input row to a single insert
> row. Any union is implicitly two or more rows.
>

Got it, so I must use this Insert in a For Select clausule.

>
>>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>

It´s a migration project from SQL-Server and my duty is to keep the same
objects on both databases, so it´s no my decision. :-(

>
> /hb

Thanks Helen.

Best regards

Luciano R. Machado