title: sql selecting from view and table
body: <p>I have a select query in which I would like to do a join on a view and another table.
  The view works fine and so does the table, separately. But when I try to do something like:</p>
  
  <pre><code>select VIEW.col1, VIEW.col2
  from VIEW, TABLE
  where VIEW.col1 = TABLE.col1
  </code></pre>
  
  <p>I get <code>The multi-part identifier "VIEW.col1" could not be bound.</code></p>
  
  <p>Is the syntax wrong, or is that just not allowed on views?</p>