|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
27/12/2007, 04h02
|
#1 |
Messages: n/a
Hébergeur: |
derived select can't find table
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 |
|
|
27/12/2007, 13h21
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: derived select can't find table
Hi,
On Dec 26, 2007 11:02 PM, wang shuming <wangshuming01@gmail.com> 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/...trictions.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." |
|
|
 |
| Outils de la discussion | |
|
|
