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
> FROM subcatsicbond
> LEFT JOIN suppliersiclink ON subcatsicbond.siccode=suppliersiclink.sic_code
> LEFT JOIN supplier ON suppliersiclink.sup_id=supplier.id
> WHERE ((subcatsicbond.sub_catid=20) AND (supplier.max_latitude<=32.99) AND
> (supplier.min_latitude>=31.55) AND (supplier.min_longitude>=89.25) AND
> (supplier.max_longitude<=90.97))
> ORDER BY supplier.company_name ASC LIMIT 0,10;
FWIW, I had the same problem - I just re-wrote my queries: "select blah from table1,
table2, table3 where table1.field=table2.field ..."
I'm sure I'm doing something wrong, but I haven't had time to dig in and figure it out.
--
Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone
http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager
I sometimes wonder if the American people deserve to be free - they seem
so unwilling to fight to preserve the few freedoms they have left.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php