SKT.*, yaptım ama stok kartı detayı getiremedim bir türlü
(14/01/2022, 13:37)berduş yazdı: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;