Alias for column name on a SELECT * join
<p>I have two tables -  client and person. They are linked by <code>personID</code> in both tables.</p>

<p>I am trying to create a view.</p>

<p>I tried:</p>

<pre><code>SELECT * FROM client INNER JOIN person ON client.personID = person.personID
</code></pre>

<p>It didn't like it saying <code>Duplicate column name 'personID</code>. </p>

<p>I thought if you used <code>table.column</code> that was fine as an identifier. I tried with and without single quotes.</p>

<p>I could do an alias if I wanted specific columns EG <code>client.personID AS perID</code> but I cannot work out how to make an alias for the columns in this position IE when they are part of the JOIN definition.</p>

<p>I have been looking and trying for over an hour and just cannot find it.</p>

<p><strong>EDIT:</strong> This is a question SPECIFICALLY about aliasing columns in a SELECT * join. Everyone seems to be saying put in the explicit columns. I know how to do that. I deliberately want to use a * JOIN for development work. This will be a tiny DB so it does even not matter if it stays in. Oh and <strong>this is only a problem storing as a VIEW not as an SQL query or in a bit of code</strong>.</p>