List:General Discussion« Previous MessageNext Message »
From:wang shuming Date:April 5 2007 5:39am
Subject:5.0.37 ,sql a table still not found
View as plain text  
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
Thread
5.0.37 ,sql a table still not foundwang shuming5 Apr
  • RE: 5.0.37 ,sql a table still not foundEdwin \(GE, Corporate, consultant\) Cruz5 Apr