title: Big Query: SQL JOIN with column prefix
body: <p>I have two tables in Google Big Query. One table is kind of a product catalogue (1:1), while the second one is product related information (1:n). For a query I'm joining both. But the joins fails since the column <code>pid</code> and some others are present in both tables.</p>
  
  <pre><code>#standardSQL
  SELECT tbl1.*, tbl2.* FROM (
    SELECT * FROM `my_project.my_dataset.my_table_1`
    ) AS tbl1
  LEFT JOIN ( SELECT * FROM `my_project.my_dataset.my_table_2`) AS tbl2
  ON tbl1.pid = tbl2.pid
  WHERE tbl1.category LIKE '111002%'
  </code></pre>
  
  <p><strong>Idea 1:</strong> How to select <code>*</code> without the duplicated columns (that I can put in manually). </p>
  
  <p><strong>Idea 2:</strong> How to provide a left/right prefix for the columns in the join?</p>
  
  <p>Any help is appreciated.</p>