in mysql doc you could find a better answer of your problem
(http://dev.mysql.com/doc/refman/5.0/en/join.html) have a look on the part
"Join Processing Changes in MySQL 5.0.12" but that you have to do is use
implicit joins:
select *
from a1 inner join a2 on a1.f2=a2.f2
left join b1 on a1.f1 = b1.f1
Regards!!!
--
Ing. Edwin Cruz
Software Engineer, GE Treasury - Risk Systems
Softtek - GDC Aguascalientes
-----Original Message-----
From: wang shuming [mailto:[EMAIL PROTECTED]
Sent: Jueves, 05 de Abril de 2007 12:39 a.m.
To: [email protected]
Subject: 5.0.37 ,sql a table still not found
Hi,
from 5.0.27 till now 5.0.37, porblem still like this:
select * from a1,a2
left join b1 on b1.f1=a1.f1
where a2.f2=a1.f2
// shows table a1 does not exist.
if SQL changes into
select * from a2,a1
left join b1 on b1.f1=a1.f1
where a2.f2=a1.f2
// SQL runs OK.
Thanks!
Shuming　Wang
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
