title: Same value showing up as three values
body: <p>I have column (Builder) in my database that I want to update the three values for and make it one single value since it is all the same but our data source treats it separately. I do not know what the dilemma is that even after the update statement, database still treats them as separate values. My data source shows a total of 5 rows and so does my database. What can I do to treat them as one, single value rather than three? </p>
  
  <pre><code>select * from traffic
  
  Builder                      Contacts
  
  Small Brother                   0
  Big Brother                     8 
  Brother                         10 
  Neighbor                        7 
  Friend                          5
  </code></pre>
  
  <p>I updated values in my table:</p>
  
  <pre><code>update traffic set Builder = 'Brothers' WHERE Builder in ('Brother',
       'Big Brother','Small Brother') ;
  </code></pre>
  
  <p>When I do </p>
  
  <pre><code>select distinct Builder from traffic
  
  Builder
  
  Brothers
  Neighbor
  Friend
  </code></pre>
  
  <p>It shows up as one value which is 'Brothers' meaning the update statement executed successfully.</p>
  
  <p>Surprisingly, when I run</p>
  
  <pre><code> select * from traffic
  
   Builder              Contacts
  
   Brothers              0
   Brothers              8
   Brothers              10
   Neighbor              7
   Friend                5
  </code></pre>
  
  <p>When I apply an aggregate function:</p>
  
  <pre><code>select Builder, sum(Contacts)
  from traffic
  group by Builder, Contacts
  
  Builder                   Sum
  Brothers                  8
  Brothers                  10
  Neighbor                  7 
  Friend                    5
  </code></pre>
  
  <p>The result I need help with:</p>
  
  <pre><code>select * from traffic
  
  Builder              Contacts
  
  Brothers               18  
  Neighbor               7
  Friend                 5
  </code></pre>