Hi Jim, Thanks for the tip, It worked!Thanks a lot!!!Daniel Hernández.Tijuana, BC, México."More you learn, more you earn".try select ...,sum(case when sales.itemname = 'some' then sales.count else 0 end) as "Sales Candies"from your_table_heregroup by ...<[EMAIL PROTECTED]>Join Excite! - htt
Thu, 23 Feb 2006 12:46:44 -0500 (EST)
Subject: [SQL] Sum If
> Hi Guys, I'm new on this group, and I have a question, is there a way to do
> a "sum if" (kind of)
> ?What i want to do is the following.Select customers.custid, if
> (sales.itemname = 'candy',
Hi Guys, I'm new on this group, and I have a question, is there a way to do a "sum if" (kind of)?What i want to do is the following.Select customers.custid, if (sales.itemname = 'candy', sum(sales.count)) as "Sales candies", if (sales.itemname = 'some', sum(sales.count)) as "Sales Some"from ...j
