Select all fields from table A but single field from B?
<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>