title: Select from the result of a union query, Oracle
body: <p>I am trying to do a select on the result of a union. I am running Oracle 11g. I ran the following query and I get <code>ORA-00933: SQL command not properly ended</code></p>
  
  <p>I looked at a lot of other posts and this should work, however it doesn't for me. Any help will be appreciated. </p>
  
  <pre><code>SELECT tbl.name
  FROM
  (
      SELECT name FROM customer
      UNION
      SELECT name FROM vendor
  ) AS tbl;
  </code></pre>