SELECT ISNULL(SUM(CASE WHEN GCKOD='G' THEN MIKTAR WHEN GCKOD='C' THEN (-1*MIKTAR) END),0) AS MIKTAR FROM TBLSERITRA WHERE SERI_NO='" + seriNo + "' AND STOK_KODU='" + stokKodu + "' AND DEPOKOD='" + depoKodu + "' AND SUBE_KODU='" + sube + "'