Posted by Sam.Moretta on 01/10/06 03:16

Its OK, I figured it out.
I ended up using

SUM(CASE WHEN Line_type = 10 THEN costs else 0 END),

SUM(CASE WHEN Line_type <> 10 THEN Totals else 0 END)


THanks for the help guys :)

[Back to original message]