| Subject | insert into select ... union ... |
|---|---|
| Author | unordained |
| Post date | 2004-10-25T10:14:47Z |
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?
-Philip
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?
-Philip