title: Syntax error in SQL query
body: <p>I am having problems implementing this query in vb.net.
  The error message that I am getting is with the "as" in the first line.
  This is a local sql compact database 3.5</p>
  
  <pre><code>        cmd.CommandText = "UPDATE player as a " &amp;
                              "SET starter = 'TRUE' " &amp;
                              "WHERE NOT EXISTS (SELECT '1' " &amp;
                              "FROM player AS b " &amp;
                              "WHERE(b.school = a.school) " &amp;
                              "AND b.weight = a.weight " &amp;
                              "AND b.skill &gt; a.skill)"
          cmd.ExecuteNonQuery()
  </code></pre>
  
  <p>Error message - <a href="http://i40.tinypic.com/34gms5z.png" rel="nofollow">http://i40.tinypic.com/34gms5z.png</a></p>
  
  <pre><code>        cmd.CommandText = "UPDATE a " &amp;
                  "SET starter = 'TRUE' " &amp;
                  "FROM player a " &amp;
                  "LEFT JOIN player b " &amp;
                  "ON a.school = b.school " &amp;
                  "AND a.weight = b.weight " &amp;
                  "AND b.skill &gt; a.skill " &amp;
                  "WHERE b.school is NULL"
          cmd.ExecuteNonQuery()
  </code></pre>
  
  <p>Error message - <a href="http://i40.tinypic.com/106kn86.png" rel="nofollow">http://i40.tinypic.com/106kn86.png</a></p>