RE: 5.0.37 ,sql a table still not found

[Cruz, Edwin \(GE, Corporate, consultant\)]

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]