Select Carharcarkod,carharcarunvan,carhartar,carharvadetar,carharrefno,carhartutar,
EŞlenen Tutar'=isnull((select Sum(caresltutar) From Carodeesle Where Careslbrcrefno=carharrefno ),0.0),
Kalan Tutar'=isnull(carhartutar-(select Sum(caresltutar) From Carodeesle Where Careslbrcrefno=carharrefno ),0.00)
From Carhar
Where Carhartutar=isnull((select Sum(caresltutar) From Carodeesle Where Careslbrcrefno=carharrefno ),0.0)
Or Carhartutar-(select Sum(caresltutar) From Carodeesle Where Careslbrcrefno=carharrefno )>0
EŞlenen Tutar'=isnull((select Sum(caresltutar) From Carodeesle Where Careslbrcrefno=carharrefno ),0.0),
Kalan Tutar'=isnull(carhartutar-(select Sum(caresltutar) From Carodeesle Where Careslbrcrefno=carharrefno ),0.00)
From Carhar
Where Carhartutar=isnull((select Sum(caresltutar) From Carodeesle Where Careslbrcrefno=carharrefno ),0.0)
Or Carhartutar-(select Sum(caresltutar) From Carodeesle Where Careslbrcrefno=carharrefno )>0