title: Duplicate column name in SQL
body: <p>I've wanted to create a view in my sql but I've been getting this error:</p>
  
  <blockquote>
    <p>Duplicate column name 'product_id'</p>
  </blockquote>
  
  <p>Here's my query:</p>
  
  <pre><code>CREATE VIEW product_view AS
  
  SELECT
      *
  FROM
      products
      JOIN storeitems on products.product_id = storeitems.product_id;
  </code></pre>
  
  <p>I believe creating an alias would solve the problem but then I don't know how to do it. I hope you could help me with this. Thanks!</p>