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

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:wangshuming01@gmail.com]
Sent: Jueves, 05 de Abril de 2007 12:39 a.m.
To: mysql@lists.mysql.com
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