title: asp.net DataSource SQL syntax
body: <p>I am trying to take data from two tables and show them using a GridView.</p>
  
  <p>I keep getting an error around 'on' when running the following SQL statement:</p>
  
  <pre><code>SELECT [date], [title], [description], [views], [Id] 
  FROM [bookmarks] b 
  JOIN [creates] c (on [b.Id] = [c.bookmarkid]) 
  ORDER BY [date] DESC
  </code></pre>
  
  <p>The SQL syntax is quite different from MySQL or Oracle SQL and I do not know how to specify the aliases (I think there is the problem).</p>