Subject Re: [firebird-support] insert with select - union
Author Helen Borrie
At 11:43 AM 27/05/2004 -0300, you wrote:
>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.


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

/hb