title: Added first column in Select Case SQL, can't get the second to stay
body: <p>Trying to learn SQL on my own, and I updated this table correctly with this first statement, and the column OFF_DIVISION stayed in the Temp_NFL2015 table. </p>
  
  <pre><code>SELECT *, case when OffenseTeam in ('BUF', 'MIA', 'NYJ','NE') then 'AFC EAST' 
  when OffenseTeam in ('BAL','CIN','CLE','PIT') THEN 'AFC NORTH'
  when OffenseTeam in ('HOU','IND','JAC','TEN') THEN 'AFC SOUTH'
  when OffenseTeam in ('DEN','KC','OAK','SD') THEN 'AFC WEST'
  when OffenseTeam in ('DAL','NYG','PHI','WAS') THEN 'NFC EAST'
  when OffenseTeam in ('CHI','DET','MIN','GB') THEN 'NFC NORTH'
  when OffenseTeam in ('ATL','CAR','NO','TB') THEN 'NFC SOUTH'
  when OffenseTeam in ('ARI','STL','SEA','SF') THEN 'NFC WEST' END AS OFF_DIVISION
  INTO nfl.dbo.Temp_NFL2015
  from NFL2015$
  </code></pre>
  
  <p>Now I have a working column in Temp_NFL2015 called OFF_Division. The table keeps the column in it when I Select * from the table. </p>
  
  <p>But I am now having a problem creating the DEF_Division Column. If I run the below code, I get the results I want, but the column doesn't stay in the table permanently. I tried using INTO, but that didn't work. How can I save the below results into the table permanently? THANK YOU</p>
  
  <pre><code>SELECT *, case when DefenseTeam in ('BUF', 'MIA', 'NYJ','NE') then 'AFC EAST' 
  when DefenseTeam in ('BAL','CIN','CLE','PIT') THEN 'AFC NORTH'
  when DefenseTeam in ('HOU','IND','JAC','TEN') THEN 'AFC SOUTH'
  when DefenseTeam in ('DEN','KC','OAK','SD') THEN 'AFC WEST'
  when DefenseTeam in ('DAL','NYG','PHI','WAS') THEN 'NFC EAST'
  when DefenseTeam in ('CHI','DET','MIN','GB') THEN 'NFC NORTH'
  when DefenseTeam in ('ATL','CAR','NO','TB') THEN 'NFC SOUTH'
  when DefenseTeam in ('ARI','STL','SEA','SF') THEN 'NFC WEST' END AS DEF_DIVISION
  
  from nfl.dbo.Temp_NFL2015
  </code></pre>