Subject Re: [firebird-support] insert into select ... union ...
Author Helen Borrie
At 03:14 AM 25/10/2004 -0700, you wrote:

>Am I correct in assuming that Firebird simply doesn't allow the use of
>"union" in a "insert
>into ... select" statement? The IB6 language guide doesn't mention this --
>it only says that the
>select statement used must return one or more rows. I'd rather not have to
>create yet another temp
>table just do do a 'distinct' against the result of the union (3 selects,)
>any suggestions?

I'm still trying to figure out what you're doing here...trying to load the
output from a union select into another table, I think...

If you just want a "distinct" union set to work with, omit the ALL
keyword. The default behaviour is to exclude duplicate rows.