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)
Then
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/[EMAIL PROTECTED]
