title: Update a table column with some values in SQL Server
body: <p>I need some help or guidance on this.</p>
  
  <p>I have this situation where I don't have a primary key in the first table:</p>
  
  <pre><code>County, 
  Gender,
  EconomyName, 
  HighestEducation, 
  HighestEducationCount,
  EconomyCount
  </code></pre>
  
  <p>In a second table, I have</p>
  
  <pre><code>County, 
  Gender, 
  HighestEducation, 
  HighestEducationCount
  </code></pre>
  
  <p>I want to update the first table (<code>HighestEducaiion, HighestEducationCount</code>) from the second table value. </p>
  
  <p>How to do this without a key? Here is the sample data, EconStat,EduStatu is blank in table 1. </p>
  
  <pre><code>County  Year    Gender  AgeDetails      EconStat    EducStatu   AgeCnt  EconCnt EduCnt
  Carlow  2006    Male    Total persons                           20193   0       0
  Carlow  2006    Male    Total whose                             17215   0       0
  Carlow  2006    Male    Under 15 years                          2179    0       0
  Carlow  2006    Male    15 years                                1366    0       0
  Carlow  2006    Male    16 years                                2369    0       0
  Carlow  2006    Male    17 years                                1767    0       0
  Carlow  2006    Male    18 years                                2485    0       0   
  </code></pre>
  
  <p>In the second table</p>
  
  <pre><code>County  Year    Gender  EducStatu                                   EduCnt
  Carlow  2006    Male    Total education ceased and not ceased       20193
  Carlow  2006    Male    Total whose full-time education has ceased  17215
  Carlow  2006    Male    Primary (incl. no formal education)         3536
  Carlow  2006    Male    Lower secondary                             4408
  </code></pre>
  
  <p>Note : always less data In the second table
  Result should look like this</p>
  
  <p>County  Year    Gender  AgeDetails      EconStat    EducStatu               AgeCnt  EconCnt EduCnt
  Carlow  2006    Male    Total persons       Total education ceased and not ceased   20193   0   20193
  Carlow  2006    Male    Total whose         Total whose full-time education has ceased  17215   0   17215
  Carlow  2006    Male    Under 15 years      Primary (incl. no formal education) 2179    0   3536
  Carlow  2006    Male    15 years            Lower secondary         1366    0   4408
  Carlow  2006    Male    16 years                            2369    0   0
  Carlow  2006    Male    17 years                            1767    0   0
  Carlow  2006    Male    18 years                            2485    0   0</p>