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: 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]