title: In SQL is there a way to use select * on a join?
body: <p>Using Snowflake,have 2 tables, one with many columns and the other with a few, trying to select * on their join, get the following error:</p>
  <pre><code>SQL compilation error:duplicate column name
  </code></pre>
  <p>which makes sense because my joining columns are in both tables, could probably use select with columns names instead of *, but is there a way I could avoid that? or at least have the query infer the columns names dynamically from any table it gets?</p>