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
