title: How to join the following 3 tables with exactly one ABAP SQL statement
body: <p>I have the following 3 tables with data:  </p>
  
  <p><code>ZMYTABLE</code> with columns: <code>ZUSER</code> &amp; <code>ZTCODE</code> and 2 records  </p>
  
  <pre><code>elias  VA01  
  elias  VF01
  </code></pre>
  
  <p><code>AGR_1251</code> with the records   </p>
  
  <pre><code>SD_role  VA01  
  SD2_role VA01  
  SD3_role VA01  
  SD_role  VA02  
  FI_role  VF01  
  FI_role  VF02
  </code></pre>
  
  <p><code>AGR_USERS</code> with records  </p>
  
  <pre><code>elias  SD_role  
  elias  SD2_role   
  maria  SD_role  
  maria  FI_role
  </code></pre>
  
  <p>I want to display the fields <code>ZUSER</code>, <code>ZTCODE</code> and <code>AGR_NAME</code>.<br>
  I want all records from <code>ZMYTABLE</code> with the role in which exists each tcode for the specific user, namely:   </p>
  
  <pre><code>ZUSER---ZTCODE---AGRNAME  
  elias---VA01-----SD_role  
  elias---VA01-----SD2_role  
  elias---VF01-----        
  </code></pre>
  
  <p>Can someone tell me how to do this by joining the 3 tables with exactly one ABAP SQL statement, in ABAP V7.01 sp07?</p>