select
CONVERT(VARCHAR,CONVERT(MONEY,SUM(lMalBedeli - lMalIskontoTutari - lDipIskontoTutari) ),1) as KAToplam
--SUM(lMalBedeli - lMalIskontoTutari - lDipIskontoTutari) --

from tbAlisVeris,tbDepo , tbKasiyer
where tbAlisVeris.sMagaza = tbDepo.sDepo and
Month(dteFaturaTarihi) =Month($_GET["tarih"]) And Year(dteFaturaTarihi) =Year($_GET["tarih"]) and
tbAlisVeris.sKasiyerRumuzu = tbKasiyer.sKasiyerRumuzu

$q1 = Database::Read ("select
*******FLOOR(SUM(lToplamMiktar)) as Adet1,
********CONVERT(VARCHAR,CONVERT(MONEY,SUM(lKdvMatr ahi1 + lKdvMatrahi2 + lKdvMatrahi3+ lKdvMatrahi4+ lKdvMatrahi5) ),1)
********
*********************as KHToplam ,
***********************CONVERT(VARCHAR,CONVERT(MON EY,SUM(lMalBedeli - lMalIskontoTutari - lDipIskontoTutari) ),1) as KDToplam
********--SUM(lMalBedeli - lMalIskontoTutari - lDipIskontoTutari) --
************************
***from tbAlisVeris,tbDepo , tbKasiyer
***where tbAlisVeris.sMagaza = tbDepo.sDepo* and
********dteFaturaTarihi = CONVERT(char(10),$_GET['tarih'],103)and
********tbAlisVeris.sKasiyerRumuzu = tbKasiyer.sKasiyerRumuzu");