title: MySQL create view as join of other views, how to avoid typing all the column names?
body: <p>In order to create a view as a join of two other views I'll do the following:</p>
  
  <pre><code>CREATE VIEW view_join AS SELECT
      a.id,
      a.time,
  
      a.column1,
      a.column2,
      a.column3,
  
      b.column1,
      b.column2,
      b.column3  
  FROM view_one a INNER JOIN view_two b 
  WHERE a.id = b.id;
  </code></pre>
  
  <p>Both origin views have <code>id</code> and <code>time</code> and want them in the <code>view_join</code>, for all the other columns I want everything. My lazy side is telling must be a way to avoid typing all the column names, is it?</p>