I suggest you simplify and use distinct aliases within your queries.
On 5/15/07, Chris <dmagick@stripped> wrote:
> wang shuming wrote:
> > Hi,
> > SQL like
> > select *,(select f1 from (select f1,date from table1 t1 where
> > t1.f1=table1.f1 order by date desc limit 1 ) t2 ) lastf1
> > from table1
> > shows table1.f1 not found, mysql 5.0.37 .
> Break up your query and work out which table1 it's talking about, ie:
> select f1,date from table1 t1 where t1.f1=table1.f1 order by date desc
> limit 1
> (I assume that will work)
> select f1 from (select f1,date from table1 t1 where t1.f1=table1.f1
> order by date desc limit 1 ) t2
> Then everything together - which ones work and which ones break ?
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
- michael dykman
- All models are wrong. Some models are useful.