title: Select all fields from table A but single field from B?
body: <p>Is there a way in ABAP's OpenSQL to simplify the select columns in a <code>JOIN</code> when I want to grab all the fields of one table but only selected fields from the other table(s)?</p>
  
  <p>For instance, in mysql <a href="https://stackoverflow.com/a/14000583/1103571">we can simply do</a>:</p>
  
  <pre><code>SELECT  tb1.*, tb2.b, tb2.d
  FROM       tableA tb1
  INNER JOIN tableB tb2 ON tb1.x = tb2.a
  </code></pre>
  
  <p>However, OpenSQL does not seem to allow selecting <code>tb1~*, tb2~b, tb2~d</code> so I have to resort to this:</p>
  
  <pre><code>SELECT  tb1.x, tb1.y, tb1.z, tb2.b, tb2.d
  FROM       tableA tb1
  INNER JOIN tableB tb2 ON tb1.x = tb2.a
  </code></pre>
  
  <p>For very large tables, especially standard tables, this becomes unwieldy, difficult to read and more annoying to maintain. </p>
  
  <p><strong>Is there a better way to select all fields of tb1 and some fields from tb2?</strong></p>