title: Select the same column multiple times
body: <p>hope someone can help. I have two tables:</p>
  
  <pre><code>Users
    -UserID
    -UserName
  
  UsersType
    -UserTypeID
    -UserID
  </code></pre>
  
  <p>Possible values for UsersTypeID is 1 to 6. In that scenario Users may have multiple types and I need to retrieve a distinct row for each user with the columns described below.</p>
  
  <pre><code>UserName - Type1 - Type2 - Type3 - Type4
  Joe            0       1       1       0
  </code></pre>
  
  <p>In this scenario, Joe has two different User type (2,3)</p>
  
  <p>This might be easy as pie but I have been working around this for so long that I am clueless. Can some one help please.</p>