title: SQL Server column was specified multiple times
body: <pre><code>select 
      table12.* 
  from 
      (select *
       from [Crimes].[FactCrimes] as fact
       inner join [Crimes].[DimCrimeClassification] as crime on fact.CrimeTypeID = crime.CrimeTypeID
       where[Index Code] = 'i') as table12;
  </code></pre>
  
  <p>but I keep getting this error: </p>
  
  <blockquote>
    <p>The column 'CrimeTypeID' was specified multiple times for 'table12'</p>
  </blockquote>