SQL de UNION ALL kullandım ama bir hata alıyorum yardımcı olabilirmisinz?
Kod: Tümünü seç
SELECT 'SATIS' AS TIP, STHAR_TARIH AS TARIH, TBLSTHAR.STOK_KODU, STOK_ADI, STHAR_GCMIK AS MIKTAR, TBLCASABIT.PLASIYER_KODU,STHAR_NF * STHAR_GCMIK AS NET_TUTAR, TBLCASABIT.GRUP_KODU,
(STHAR_NF * STHAR_GCMIK) + ((STHAR_NF * STHAR_GCMIK * STHAR_KDV)/100) AS KDV_DAHIL,(STHAR_GCMIK * PAY_1) AS MIKTAR2
FROM TBLSTHAR
INNER JOIN TBLSTSABIT ON (TBLSTHAR.STOK_KODU = TBLSTSABIT.STOK_KODU)
INNER JOIN TBLCASABIT ON (TBLSTHAR.STHAR_CARIKOD=TBLCASABIT.CARI_KOD)
WHERE STHAR_HTUR IN ('H','J') AND STHAR_GCKOD='C'
UNION ALL
SELECT 'IADE' AS TIP, STHAR_TARIH AS TARIH, TBLSTHAR.STOK_KODU, STOK_ADI, STHAR_GCMIK AS MIKTAR, TBLCASABIT.PLASIYER_KODU, STHAR_NF * STHAR_GCMIK AS NET_TUTAR, TBLCASABIT.GRUP_KODU,
(STHAR_NF * STHAR_GCMIK * STHAR_KDV)/100 AS KDV, (STHAR_NF * STHAR_GCMIK) + ((STHAR_NF * STHAR_GCMIK * STHAR_KDV)/100) AS KDV_DAHIL , (STHAR_GCMIK * PAY_1) AS MIKTAR2
FROM TBLSTHAR
INNER JOIN TBLSTSABIT ON (TBLSTHAR.STOK_KODU = TBLSTSABIT.STOK_KODU)
INNER JOIN TBLCASABIT ON (TBLSTHAR.STHAR_CARIKOD=TBLCASABIT.CARI_KOD)
WHERE STHAR_HTUR IN ('L') AND STHAR_GCKOD='G'
GO
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.