[RBG7-L] - Re: UNION

[Albert Berry]

R:Base is typing one of the two columns incorrectly. Try creating a two 
column TEMP table and inserting the two SELECT clauses one after the other.

ELOEN wrote:
The command:

SEL NATPloiaKvd,MAX(NATPloiaOnoma)+
 FROM TNATYphr WHERE INT(NATPloiaKvd) > 0 GROUP BY NATPloiaKvd+
 UNION+
 SEL MAX(NATPloiaKvd),NATPloiaOnoma FROM TNATYphr WHERE+
 INT(NATPloiaKvd) = 0 GROUP BY NATPloiaOnoma

Gives:
-ERROR- Column type mismatch in UNION (2372)

Anyone knows why?

TIA
Polychronis