Mysql, subselect, where

[ChrisB]

Hi,

Unknown column 'pool_count' in 'where clause'

  
<http://dev.mysql.com/doc/refman/5.1/en/select.html>:  
"It is not allowable to refer to a column alias in a WHERE clause, because the column value might not yet be determined when the WHERE clause is executed."  
  

> Wie kann ich meta\_count und pool\_count in einer WHERE verwenden?!  
  
Gar nicht. Du kannst höchstens die SELECT EXPRESSION selber in der WHERE-Klausel (erneut) unterbringen.  
  
MfG ChrisB  
  

-- 
Light travels faster than sound - that's why most people appear bright until you hear them speak.