SELECT SHD.URUN_NO, Sum(IIf([FIS_TIPI]='Alış' and iif(ADET IS NULL, 0, ADET),0)) AS GIRIS, Sum(IIf([FIS_TIPI]='Satış' and iif(ADET IS NULL, 0, ADET),0)) AS CIKIS FROM SIPARISLER AS SHD GROUP BY SHD.URUN_NO