Polychronis,
Perhaps it is because in the UNION select statement
MAX() is the first item whereas in the first select it
is the second item. Although you can do a union like
you propose it may not give the result you expect.
Jim Bentley
American Celiac Society
--- ELOEN <[EMAIL PROTECTED]> 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
>
>
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
