Re: mysql join problem (bug?)

2002-12-02 Thread DL Neil
t; > > > 1 4 1 4 > > > > > > If that is the case, is this a Win-XP specific bug? > Can someone running versions other than MySQL 4.0.5-beta on XP verify if > it is a bug please? > > Thanks! > > > Haksun > > > -----Original Message

RE: mysql join problem (bug?)

2002-12-01 Thread Haksun Li
ecember 01, 2002 3:39 PM > To: Haksun Li; [EMAIL PROTECTED] > Subject: Re: mysql join problem (bug?) > > Hi Haksun, > Cross-join works perfectly on 3.23.53-max-nt under Win2000 SP2, both from > command line and MySQL Control Center 0.8.6-alpha. > Regards, > =dn >

Re: mysql join problem (bug?)

2002-12-01 Thread DL Neil
Hi Haksun, Cross-join works perfectly on 3.23.53-max-nt under Win2000 SP2, both from command line and MySQL Control Center 0.8.6-alpha. Regards, =dn > Hi all, > > > > I found this join problem using mysql 3.23.53-max-nt (on WinXP). > > It works fine on MySQL 3.23.52-log (on Linux). > > > > Could

mysql join problem (bug?)

2002-11-30 Thread Haksun Li
Hi all, I found this join problem using mysql 3.23.53-max-nt (on WinXP). It works fine on MySQL 3.23.52-log (on Linux). Could someone please confirm that it is a bug? Or enlighten me on writing the correct sql? I have a table and data as shown in the script below. CREATE TABLE t

Mysql join problem.

2001-01-16 Thread mailman . mail
I'm using mysql 3.23 on red hat 6.1 I want to select * from tablea and tableb where columna in tablea is the same as columnb in tableb, but columna1 in tablea DOESN'T appear in columnb in tableb. I tried select a.* from tablea as a,tableb as b where a.cid <> b.uid limit 30; it gave me the