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 > 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]
-- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
