[delphi-en] Re: SQL PROBLEM

[iqbal_delphidev]

why you are using 'D_AMOUNT' in GROUP BY clause:

Try the following:
 
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_TYPE

thanks