STOK DEVRI

SQL : INSERT INTO TUGBA12..STHAR ( STOK_KODU,FISNO,STHAR_GCMIK,STHAR_GCMIK2,CEVRIM,STHAR_GCKOD,STHAR_TARIH,STHAR_NF,STHAR_BF,STHAR_IAF,STHAR_KDV,DEPO_KODU,STHAR_ACIKLAMA,STHAR_SATISK,STHAR_MALFISK,STHAR_FTIRSIP,STHAR_SATISK2,LISTE_FIAT,STHAR_HTUR,STHAR_DOVTIP,PROMASYON_KODU,STHAR_DOVFIAT,STHAR_ODEGUN,STRA_SATISK3,STRA_SATISK4,STRA_SATISK5,STRA_SATISK6,STHAR_BGTIP,STHAR_KOD1,STHAR_KOD2,STHAR_SIPNUM,STHAR_CARIKOD,STHAR_SIP_TURU,PLASIYER_KODU,EKALAN_NEDEN,EKALAN,EKALAN1,REDMIK,REDNEDEN,SIRA,STRA_SIPKONT,AMBAR_KABULNO,FIRMA_DOVTIP,FIRMA_DOVTUT,FIRMA_DOVMAL,UPDATE_KODU,IRSALIYE_NO,IRSALIYE_TARIH,KOSULKODU,ECZA_FAT_TIP,STHAR_TESTAR,OLCUBR,VADE_TARIHI,LISTE_NO,BAGLANTI_NO,SUBE_KODU,MUH_KODU,S_YEDEK1,S_YEDEK2,F_YEDEK3,F_YEDEK4,F_YEDEK5,C_YEDEK6,B_YEDEK7,I_YEDEK8,L_YEDEK9,D_YEDEK10,PROJE_KODU,FIYATTARIHI,KOSULTARIHI,SATISK1TIP,SATISK2TIP,SATISK3TIP,SATISK4TIP,SATISK5TIP,SATISK6TIP,EXPORTTYPE,EXPORTMIK,DUZELTMETARIHI,ONAYTIPI,ONAYNUM,KKMALF,STRA_IRSKONT,YAPKOD,MAMYAPKOD,OTVFIYAT ) SELECT STHAR.STOK_KODU,STHAR.FISNO,STHAR.STHAR_GCMIK,STHAR.STHAR_GCMIK2,STHAR.CEVRIM,STHAR.STHAR_GCKOD,STHAR.STHAR_TARIH,STHAR.STHAR_NF,STHAR.STHAR_BF,STHAR.STHAR_IAF,STHAR.STHAR_KDV,STHAR.DEPO_KODU,STHAR.STHAR_ACIKLAMA,STHAR.STHAR_SATISK,STHAR.STHAR_MALFISK,STHAR.STHAR_FTIRSIP,STHAR.STHAR_SATISK2,STHAR.LISTE_FIAT,STHAR.STHAR_HTUR,STHAR.STHAR_DOVTIP,STHAR.PROMASYON_KODU,STHAR.STHAR_DOVFIAT,STHAR.STHAR_ODEGUN,STHAR.STRA_SATISK3,STHAR.STRA_SATISK4,STHAR.STRA_SATISK5,STHAR.STRA_SATISK6,STHAR.STHAR_BGTIP,STHAR.STHAR_KOD1,STHAR.STHAR_KOD2,STHAR.STHAR_SIPNUM,STHAR.STHAR_CARIKOD,STHAR.STHAR_SIP_TURU,STHAR.PLASIYER_KODU,STHAR.EKALAN_NEDEN,STHAR.EKALAN,STHAR.EKALAN1,STHAR.REDMIK,STHAR.REDNEDEN,STHAR.SIRA,STHAR.STRA_SIPKONT,STHAR.AMBAR_KABULNO,STHAR.FIRMA_DOVTIP,STHAR.FIRMA_DOVTUT,STHAR.FIRMA_DOVMAL,STHAR.UPDATE_KODU,STHAR.IRSALIYE_NO,STHAR.IRSALIYE_TARIH,STHAR.KOSULKODU,STHAR.ECZA_FAT_TIP,STHAR.STHAR_TESTAR,STHAR.OLCUBR,STHAR.VADE_TARIHI,STHAR.LISTE_NO,STHAR.INCKEYNO,STHAR.SUBE_KODU,STHAR.MUH_KODU,STHAR.S_YEDEK1,STHAR.S_YEDEK2,STHAR.F_YEDEK3,STHAR.F_YEDEK4, (CASE WHEN STSABIT.CIKIS_SERI = 'E' THEN -10000 ELSE -30000 END),STHAR.C_YEDEK6,STHAR.B_YEDEK7,STHAR.I_YEDEK8,STHAR.L_YEDEK9,STHAR.D_YEDEK10,STHAR.PROJE_KODU,STHAR.FIYATTARIHI,STHAR.KOSULTARIHI,STHAR.SATISK1TIP,STHAR.SATISK2TIP,STHAR.SATISK3TIP,STHAR.SATISK4TIP,STHAR.SATISK5TIP,STHAR.SATISK6TIP,STHAR.EXPORTTYPE,STHAR.EXPORTMIK,STHAR.DUZELTMETARIHI,STHAR.ONAYTIPI,STHAR.ONAYNUM,STHAR.KKMALF,STHAR.STRA_IRSKONT,STHAR.YAPKOD,STHAR.MAMYAPKOD,STHAR.OTVFIYAT FROM STHAR INNER JOIN TBLSTSABIT STSABIT ON (( IsNull(STSABIT.GIRIS_SERI, '' ) <>'E' OR IsNull(STSABIT.CIKIS_SERI, '' ) <> 'E') AND STSABIT.STOK_KODU = STHAR.STOK_KODU) WHERE STHAR.SUBE_KODU = 0 and STHAR.STHAR_TARIH > '12/31/2011'

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.(NetsisMS-21000,512)

The statement has been terminated.(NetsisMS-01000,3621)