SELECT TBL.GIRIS, TBL.CIKIS, ([TBL].[GIRIS]-[TBL].[CIKIS]) AS KALAN

FROM URUNLER AS SKT LEFT JOIN (SELECT CLng([URUN_NO]) AS XUrunNo, Sum(IIf([FIS_TIPI]='Alış',IIf(ADET Is Null,0,ADET),0)) AS GIRIS, Sum(IIf([FIS_TIPI]='Satış',IIf(ADET Is Null,0,ADET),0)) AS CIKIS

FROM SIPARISLER

WHERE (((SIPARISLER.TARIH)<=#1/12/2022# And (SIPARISLER.TARIH)>=#1/11/2022#))

GROUP BY CLng([URUN_NO]))  AS TBL ON SKT.URUN_NO = TBL.XUrunNo;