Posted by Sam.Moretta on 01/10/06 02:57

Is there a way to say

SUM(CASE Line_type WHEN 10 THEN costs else 0 END),
SUM(CASE Line_type WHEN NOT 10 THEN Totals else 0 END) ?

• Next in forum: Re: Combining 3 SQL statements
• Prev in forum: Re: How to omit Schema name when referrring to Tables?
• Thread view: Re: Combining 3 SQL statements

[Reply to this message]