How do I create this output in SQL
<p>I have this information.</p>

<p>Table OrderTotals</p>

<pre><code>Order  Value
A         10
B         20
C         15
</code></pre>

<p>Table Orderdetails</p>

<pre><code>Order  Line Description
A        11 Red
B        24 Blue
B        25 Green
B        28 Yellow
C        17 Green
</code></pre>

<p>And I want this output</p>

<pre><code>Order Line Description Value
A       11 Red         10
B       24 Blue        20
B       25 Green
B       28 Yellow
C       17 Green       15
</code></pre>

<p>Is this possible? And if yes, how?</p>