subject:"Broken Select\/Join"

Re: Broken Select/Join

2001-02-20 Thread Ed Carp

Johnny Withers ([EMAIL PROTECTED]) writes: > I have recently upgraded from MySQL 3.22.27 to 3.23.33. > I'm running Redhat Linux 6.1 on a p2 300 w/128MB of ram. > > The following select statement worked fine in mysql 3.22.27: > > SELECT supplier.id,subcatsicbond.sub_catid,subcatsicbond.siccode >

Broken Select/Join

2001-02-20 Thread Johnny Withers

I have recently upgraded from MySQL 3.22.27 to 3.23.33. I'm running Redhat Linux 6.1 on a p2 300 w/128MB of ram. The following select statement worked fine in mysql 3.22.27: SELECT supplier.id,subcatsicbond.sub_catid,subcatsicbond.siccode FROM subcatsicbond LEFT JOIN suppliersiclink ON subcatsic