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

Reply via email to