title: Select only specific columns in SQL joins and assign `alias`
body: <p>I have the below SQL code from <a href="https://stackoverflow.com/questions/25763379/mysql-retrieve-data-from-multiple-tables">this answer</a> to my previous question:</p>
  
  <pre><code>SELECT *
  FROM Portfolio
  INNER JOIN Client ON Portfolio.Client_id=Client.id
  INNER JOIN Provider ON Client.Provider_id = Provider.id
  </code></pre>
  
  <p>This code return the data I need However in <code>Client</code> table, I only want the "Name" column and from the <code>Provider</code> table I only need the "Name" column, while I need all the columns from the <code>Portfolio</code> table. I also need to replace the title of the <code>Name</code> column of the <code>Provider</code> table into <code>Provider Name</code> and the <code>Name</code> column in the <code>Client</code> table into <code>Client Name</code>. So, I tried below,</p>
  
  <pre><code>SELECT *
  FROM Portfolio
  INNER JOIN Client.Name "Client Name" ON Portfolio.Client_id=Client.id
  INNER JOIN Provider.Name "Provider Name" ON Client.Provider_id = Provider.id
  </code></pre>
  
  <p>and it didn't work. </p>