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 :)

• Next in forum: Re: vs MySQL
• Prev in forum: Re: Combining 3 SQL statements
• Thread view: Re: Combining 3 SQL statements

[Reply to this message]