Combining Queries into one Display Line in DB2
<p>The relevant (greatly abbreviated) part of my SQL:</p>

<pre><code>Select 
A.Client_ID,
,CASE
  WHEN FN.FLD_CD = 1
  THEN
      FN.AMOUNT
      ELSE
      NULL
  END AS "LN1"
,CASE
  WHEN FN.FLD_CD = 2
  THEN
       FN.AMOUNT
      ELSE
      NULL
  END AS "LN2"
,CASE
  WHEN FN.FLD_CD = 3
  THEN
      FN.AMOUNT
      ELSE
      NULL
  END AS "LN3"
  (...and so on)
  FROM
  ASSESSMENT A,
  FINANCE FN
  WHERE
   A.CLIENT_ID     = FN.CLIENT_ID
   AND FN.FLD_CD IN ( '1', '2', '3')
   (other irrelevant stuff)
   ;
</code></pre>

<p>This displays the results from the Query on 3 separate lines (one for each field code). How do I get it to display all on one line?</p>

<p>For example, the Results are:</p>

<pre><code>Client_ID   LN1    LN2     LN3
10001       20     -       -
10001       -      30      -
10001       -      -       40
</code></pre>

<p>but I would like it like this:</p>

<pre><code>Client ID   LN1    LN2   LN3
10001       20     30    40
</code></pre>