title: MySQL create view joining two whole tables
body: <p>How can I create a view that merges different all columns from two different tables.</p>
  
  <pre><code>CREATE VIEW listView 
  AS 
  SELECT * FROM tab1 h LEFT JOIN tab2 b 
  ON h.tID=b.tID 
  WHERE value = 0
  </code></pre>
  
  <p>this give me the error:</p>
  
  <blockquote>
    <p>Duplicate column name 'tID'</p>
  </blockquote>
  
  <p>Is there a way to join the two tables without listing all the values to select?</p>