Posted by Jens on 01/09/06 10:52

Try this one here:

Select
header_id,
header_desc,
SUM(CASE Line_type WHEN 2 THEN costs else 0 END),
SUM(CASE Line_type WHEN 10 THEN Totals else 0 END)
FROM headers
INNER JOIN
line
ON line.header_id = header.header_id


HTH, jens Suessmeyer.

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

[Reply to this message]