title: SQL link tables and convert rows in columns
body: <p>I have 2 tables:</p>
  
  <p><strong>operations</strong></p>
  
  <pre><code>opCode  opDescription  
  001       DESC_01
  002       DESC_02
  003       DESC_03
  004       DESC_04
  ..        ..
  </code></pre>
  
  <p><strong>clients</strong></p>
  
  <pre><code>opCode  cliCode    clDescription  
  001       C001         DESCR xx
  001       C002         DESCR yy
  002       C005         DESCR bb
  002       C001         DESCR cc
  002       C006         DESCR gg
  002       C003         DESCR dd
  ..        ..           ..
  </code></pre>
  
  <hr>
  
  <p>I need to join and convert rows in columns</p>
  
  <pre><code>opCode   opDescription    cliCode1   clDescription1  cliCode2   clDescription2    cliCode3   clDescription3   .. ..  cliCode5   clDescription5 
  001          DESC_01         C001       DESCRxx       C002       DESCRyy                   
  002          DESC_02         C005       DESCRbb       C001       DESCRcc              C006      DESCRgg         C003      DESCRdd      
  </code></pre>
  
  <p>Only could exist from 0 to 5 clientes linked</p>
  
  <p>any ideas? </p>