title: Nested select in mysql v 3.23
body: <p>I want write this sql select statment in mysql v 3.23</p>
  
  <pre><code>select * 
      from radacct 
      where username in ( 
          select username 
              from radcheck 
              where Attribute = 'max-weekly-session'
      );
  </code></pre>
  
  <p>but say </p>
  
  <pre><code>ERROR 1064: You have an error in your SQL syntax near 
  'select username from radcheck where Attribute= 'max-weekly-session')' 
  at line 1
  </code></pre>
  
  <p>in mysql v 5 this is ok but how can I do in v 3.23?</p>