title: MYSQL: from subquery with where
body: <p>I'm trying to do this query: </p>
  
  <pre><code>SET @NUMBER:=0;
  SELECT *, @NUMBER:=@NUMBER+1 AS NUMBER FROM(
      SELECT * 
      FROM CTBQ 
  ) AS TB1
  WHERE TB1.NUMBER &gt; 1 
  </code></pre>
  
  <p>but this error happens: Unknown column 'TB1.NUMBER' in 'where clause'</p>
  
  <p>why can't I do this?</p>
  
  <p>can anyone help me?</p>