title: How to avoid duplicate columns in SQL
body: <p>I'm very new to ms sql and joins. Please can someone guide me through this process.</p>
  <p>The query below works, however it duplicates a lot of columns that are in both tables.</p>
  <pre class="lang-none prettyprint-override"><code>Select *
  From ['BP Ref _ Customer Name$']
  inner join ['Road 2010 - Current$']
  on ['BP Ref _ Customer Name$'].[Client Order]=['Road 2010 - Current$'].[Client Order]
  </code></pre>
  <p>However, when I try to specify the columns I want the query to select in ['BP Ref _ Customer Name$'] table I get an error.</p>