Sososo - 9 days ago 5
SQL Question

# Select Query for specific sum (Not Fixed)

I want to subtract Total Amount - Paid Amount amount in first table (tutar) paid amount in second table (odemetutari)

How can I make this for grid view and show tckimlikno,adisoyadi,calculated new amount

``````SELECT  sum(tutar) AS IcraTutari ,tckimlikno
FROM Om_icra_infos
where tckimlikno=tckimlikno
group by  tckimlikno
``````

First here find same tutar with same tckimlikno

and second here

``````SELECT sum(odemetutari)
FROM Om_icraodeme_infos
where tckimlikno=tckimlikno
``````

I want to his for each row show first tutar - second odemetutari = calculatedamount and show this in new selected view

like this:

``````tckimlikno  calculatedamount
1111111111  111,22   ( tutar-odemetutari)
``````

Answer
``````select a.tckimlikno,sum(tutar)-sum(odemetutari) as calculatedamount from
Om_icra_infos a join Om_icraodeme_infos b on a.tckimlikno=b.tckimlikno group by a.tckimlikno;

(or)

select t1.tckimlikno,IcraTutari-icraodeme as calculatedamount from
(SELECT  tckimlikno,sum(tutar) AS IcraTutari FROM Om_icra_infos where tckimlikno=tckimlikno  group by  tckimlikno)as t1 join
(SELECT tckimlikno,sum(odemetutari) as icraodeme FROM Om_icraodeme_infos where tckimlikno=tckimlikno   group by  tckimlikno) as t2
on t1.tckimlikno=t2.tckimlikno groyup by t1.tckimlikno;
``````
Source (Stackoverflow)
Comments