Subject insert into select ... union ...
Author unordained
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?