ed to be an "and" and not an or.
Donny
> -Original Message-
> From: Andy Bakun [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 10, 2004 2:29 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: The UNION makes us strong^H^H^H^Hcrazy
>
On Fri, 2004-09-10 at 14:12, [EMAIL PROTECTED] wrote:
> 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)
>
> What am I doing wrong here? I have two valid SELECT
+1-516-496-3160when you do call for them?"
> -Original Message-
> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 10, 2004 12:24 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: The UNION makes us strong^H^H^H^Hcrazy
>
&g
> 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,
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
sel
