title: CASE statements - Making the THEN display information from another column
body: <p>Good morning All,</p>
  
  <p>I had a question regarding case statements. Let me set up a scenario that I am having a hard time with. Say we have a table with all of our providers licenses. Each provider can have anywhere from one to a number of licenses. I want to create a case statement that says basically WHEN the providers license type equals this, then display the license number from this different column holding the values for their numbers.</p>
  
  <p>Hope this makes sense. I do not want it to display words such as THEN 'Primary Care Physician' , instead would like it to provide the actual license number in the THEN. </p>
  
  <p>Any ideas? Thank you!</p>