title: Creating a view from a union query
body: <p>I'm sorry to have to bring up this as well. But it doesn't seem like I am getting any luck today. I have concatenated all my results into "Unioned" and am now attempting to push this into a view. This should be simple as well, but I can't seem to shift various components around to get it to work. This is the code I am trying to use:</p>
  
  <pre><code>CREATE VIEW v AS
  SELECT *
  FROM
  (
    (SELECT maker, model, price FROM product NATURAL JOIN laptop)
      UNION
    (SELECT maker, model, price FROM product NATURAL JOIN pc)
      UNION
    (SELECT maker, model, price FROM product NATURAL JOIN printer)
  ) `Unioned`
  </code></pre>
  
  <p>Error: <code>#1349 - View's SELECT contains a subquery in the FROM clause</code></p>
  
  <p>I have been trying to encapsulate various components into parenthesis. Or create a new statement just for creating the view. This question should be fairly simple to answer, but I'm just not seeing it.</p>