Hi,
On Dec 26, 2007 11:02 PM, wang shuming <[EMAIL PROTECTED]> wrote:
> Hi,
> select * , ( select f2
> from (select f1,f2 from t2 where t2.id=t1.id limit 1 union
> all ... order by f1 ) t2
> limit 1
> ) f2
>from t1
> Unknown column ' t1.id' in 'where clause'
>
> Best regard!
> Shuming Wang
>
Read this page:
http://dev.mysql.com/doc/refman/5.0/en/subquery-restrictions.html
"Subqueries in the FROM clause cannot be correlated subqueries. They
are materialized (executed to produce a result set) before evaluating
the outer query, so they cannot be evaluated per row of the outer
query."
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]