title: Table aliasing of the result set
body: <p>How to store the result set of the given query in a new table.</p>
  
  <pre><code>select   d1.year,d1.month,d1.Circle_code,d1.Call_type_code,d1.DescId,d1.CustId,
  d1.call_logged,d2.Call_Cancel
  from dbo.Table_M_CALL_LOGGED as d1 
  join dbo.Table_M_CALL_CANCEL as d2 on
  
  d1.year=d2.year
  and d1.month=d2.month
  and d1.Circle_Code=d2.Circle_Code
  and d1.Call_Type_Code=d2.Call_Type_Code
  and d1.DescId=d2.DescId
  and d1.CustId=d2.custID
  </code></pre>