title: Sql combining two column into one variable
body: <p>I have a sql command</p>
  
  <pre><code>SELECT A.*,
         K1.AD CONTACTAD,
         K1.SYD CONTACTSYD,
         KR.AD KURUM,
         K2.AD SUPERVISORAD,
         K2.SYD  SUPERVISORSOYAD,
         K3.AD REQUIRERAD,
         K3.SYD REQUIRERSOYAD
  FROM  
         TD_ACTIVITY A,
         KK_KS K1,
         KK_KS K2,
         KK_KS K3,
         KK_KR KR
  WHERE  A.INS_CONTACT_PERSON = K1.ID
     AND A.SUPERVISOR =  K2.ID
     AND A.REQUIRERID = K3.ID 
     AND A.INSTITUTIONID = KR.ID
  </code></pre>
  
  <p>I want to combine <code>CONTACTAD</code> and <code>CONTACTSOYAD</code> into one variable like <code>CONTACT</code>.How can i do that?</p>