I am returning to many rows In the following sql embedded sql will return three(3) rows. so I get a sum for each row that is return ex embedded sql returns x,y,z of course x,y,and z are really integers sum 100 for x sum 1oo for y sum 100 for z sum 200 for x sum 200 for y sum 200 for z sum 300 for x sum 300 for y sum 300 for z when all I want is sum 100 for x sum 200 for y sum 300 for z
select DISTINCT SUM(D_AMOUNT),D_TYPE FROM TYPE_DONATION, DONATIONS WHERE TYPE_DONATION.DONATION_ID IN (SELECT DISTINCT DONATION_ID FROM DONATIONS WHERE MEMID = 4) GROUP BY D_AMOUNT, D_TYPE Thanks in advance for my over sight Tony
