title: SQL : Replace integer with string when there is empty value
body: <p>I am doing something very similar to this SO thread (<a href="https://stackoverflow.com/questions/924442/sql-select-replace-integer-with-string">link</a>). The difference is that my table sometimes has empty value. Here is the illustration below following the link that I provide.</p>
  
  <p>1) Table 'people' that contain list of people with their favorite sport</p>
  
  <pre><code>ID | Name  | FavSport | DislikeSport
  ------------------------------------
  1  | Bob   |    1     |      5
  2  | Roy   |    3     |      4
  3  | Sarah |          |       
  4  | Kevin |    2     |      
  5  | Mary  |          |      3
  </code></pre>
  
  <p>2) Table 'sports' that show the list of the sport</p>
  
  <pre><code>ID |   Sport    
  ---------------
  1  | Football   
  2  | Basketball  
  3  | Volleyball  
  4  | Soccer    
  5  | Badminton 
  </code></pre>
  
  <p>The query I get from the link I post in this thread</p>
  
  <pre><code>select people.Name, sports.Sport 
  from people, sports 
  where people.FavSport = sports.ID
  </code></pre>
  
  <p>3) The Result if the query similar like above</p>
  
  <pre><code>Name  | Sport      | Dislike
  ----------------------------
  Bob   | Football   | Badminton 
  Roy   | Volleyball | Soccer    
  Sarah | Football   | Football   
  Kevin | Basketball | Football   
  Mary  | Football   | Volleyball  
  </code></pre>
  
  <p>4) What I want is empty like below (or any default value like : nothing)</p>
  
  <pre><code>Name  | Sport      | Dislike
  ----------------------------
  Bob   | Football   | Badminton 
  Roy   | Volleyball | Soccer    
  Sarah |            | 
  Kevin | Basketball | 
  Mary  |            | Volleyball  
  </code></pre>
  
  <p>Anyone how to deal with this problem? Thanks in advance.</p>