SQL PROBLEM

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_AMUNT),D_TYPE
FRM TYPE_DNATIN, DNATINS
WHERE TYPE_DNATIN.DNATIN_ID IN (SELECT DISTINCT DNATIN_ID FRM
DNATINS WHERE MEMID = 4)
GRUP BY D_AMUNT, D_TYPE

Thanks in advance for my over sight

Tony

select distinct D_amount,D_TYPE
from (
select distinct SUM(D_AMUNT),D_TYPE
FRM TYPE_DNATIN, DNATINS
WHERE TYPE_DNATIN.DNATIN_ID IN (SELECT DISTINCT DNATIN_ID FRM
DNATINS WHERE MEMID = 4)
GRUP BY D_AMUNT, D_TYPE) as Tmp

Bye bye Daniela