I don't know about the UNION, but I think you need to put parentheses around (INT(NATPloiaKvd)) and (MAX(NATPloiaOnoma)).
> -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of ELOEN > Sent: Wednesday, October 05, 2005 2:26 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - UNION > > 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 > > --- RBG7-L > ================================================ > TO POST A MESSAGE TO ALL MEMBERS: > Send a plain text email to [email protected] > > (Don't use any of these words as your Subject: > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: INTRO > ================================================ > TO UNSUBSCRIBE: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: UNSUBSCRIBE > ================================================ > TO SEARCH ARCHIVES: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: SEARCH-n > (where n is the number of days). In the message body, > place any > text to search for. > ================================================
