Ah, so it is. Thanks.
-- Dave Weingart, Sr. Programmer/Analyst "I can call modules from the vasty Private Label Services deep." -- "Why, so can I, or so can Voice: +1-516-682-1470 any programmer. But will they run FAX : +1-516-496-3160 when 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 > > > > > > 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
