I suggest you simplify and use distinct aliases within your queries.
- michael
On 5/15/07, Chris <[EMAIL PROTECTED]> 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
>
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, i
