title: Syntax error when creating view
body: <p>I have the following little bit of MySQL code </p>
  
  <pre><code>CREATE VIEW UserResults AS 
     SELECT E.No, E. Description
        , Count(R.RID WHERE $Username= R.Owner)
        , Count(R.RID WHERE $Username= R.Owner AND Status==’Active’ ) 
     FROM ETable AS E, RTABLE as R
     ORDER BY E.No)
  </code></pre>
  
  <p>but MySQL is returning a syntax error that I can't seem to find. Also when I have created this view, how can I make it viewable?</p>