table not found

[wang shuming]

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 .

Thanks!
Shuming Wang