title: Merge output as one
body: <pre><code>    Select Category, Books.ISBN,
  Orderitems.Quantity * (Books.Retail - Books.Cost) AS Category_Profit
  From BOoks
  INNER JOIN Orderitems
  ON BOOKS.ISBN=ORDERITEMS.ISBN
  </code></pre>
  
  <p>Example output:</p>
  
  <pre><code>Category            ISBN           Category_Profit
  Family life         1234                 50
  Family Life         1234                 50
  Family Life         1234                 100
  Fitness             4321                 10
  Fitness             4321                 20
  </code></pre>
  
  <p>So forth and so forth,</p>
  
  <p>How can I make the output calculate all the values for each category into one line? </p>
  
  <p>I.e</p>
  
  <pre><code>Family Life        1234     200
  Fitness            4321     30
  </code></pre>