From: Martijn Tonies
Date: September 10 2004 7:23pm
Subject: Re: The UNION makes us strong^H^H^H^Hcrazy
List-Archive: http://lists.mysql.com/mysql/172417
Message-Id: <000901c4976b$b0b73cb0$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit



> In a further followup to my needing to combine colummns, I have the two
> following SELECTS that each work when I do them alone
>
> select empssn,paycode_1,payrate_1 from paympe where not paycode_1 = '000'
> select empssn,paycode_2,payrate_2 from paympe where not paycode_2 = '000'
>
> However, when I do
>
> select empssn,paycode_1,payrate_1 from paympe where not paycode_1 = '000'
> union all
> select empssn,paycode_2,payrate_2 from paympe where not paycode_2 = '000'
>
> I get a syntax error
>
> According to the docs, this should work in versions past mySQL 4, and I
seem
> to be running a version rather later than that
>
> mysql  Ver 11.18 Distrib 3.23.52, for pc-linux (i686)

Isn't this MySQL version 3.23?

Try a:
select version()


> What am I doing wrong here? I have two valid SELECT statements; the field
> sizes and types are the same (indeed, empssn is the same field).  This
> SHOULD provide me with what I'm looking for, but...

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com