Sorgu İsteği

merhaba arkadaşlar şimdi bir sorgum var elimde qerty de sorguladığımda hatasız olarak veriyor verileri ama view oluşturmak için sorgu başına

create view as view_adi yapıyorum hata veriyor sorgulamada sizce sorgunun neresinde hata var olabilir. yardımlarınızı bekliyorum

SELECT
F.DATE_ AS [FATURA TARİHİ],
F.FICHENO AS [BELGE NO],
C.DEFINITION_ AS MÜŞTERİ,
C.TAXOFFICE AS [VERGİ DAİRESİ],
C.TAXNR AS [VERGİ NO],
S.AMOUNT AS MİKTAR,
M.NAME AS [MALZEME ADI],
S.VAT AS KDV,
S.VATMATRAH AS MATRAH,
S.VATAMNT AS [KDV TUTARI]
FROM         LG_211_01_STLINE S
LEFT OUTER JOIN LG_211_01_INVOICE F ON S.INVOICEREF = F.LOGICALREF
LEFT OUTER JOIN LG_211_CLCARD C ON C.LOGICALREF = F.CLIENTREF
LEFT OUTER JOIN LG_211_ITEMS M ON S.STOCKREF = M.LOGICALREF
LEFT OUTER JOIN LG_211_EMUHACC MUH ON S.VATACCREF = MUH.LOGICALREF
WHERE     (F.TRCODE = 8 ) AND (F.CANCELLED = 0 ) AND (MUH.CODE IS NOT NULL)
ORDER BY [FATURA TARİHİ]

SELECT 'STOK' AS TUR,
A.DATE_ AS TARIH,A.CYPHCODE AS SERINO,A.GRPCODE AS GRUP_KODU,C.STFICHELNNO AS FIS_SATIR_NO,A.FICHENO AS FIS_NO,A.DOCODE AS BELGE_NO,B.CODE AS CARIHESAP_KODU,B.DEFINITION_ AS CARIHESAP_TANIMI,B.TAXNR AS VERGI_NO,B.TAXOFFICE AS VERGI_DAIRESI,D.CODE AS STOK_KODU,D.NAME AS STOK_TANIMI,C.AMOUNT AS MIKTAR,C.PRICE AS BIRIM_FIYAT,(CASE C.PRCURR WHEN 0 THEN 'TL' WHEN 1 THEN 'DOLAR' WHEN 20 THEN 'EURO' END) AS ISLEM_DOVIZ_TURU,C.PRPRICE AS ISLEM_DOVIZ_FIYATI,C.VAT AS KDV_ORANI,C.VATMATRAH AS KDVMATRAHI,C.VATAMNT AS KDVTUTAR,C.LINENET AS FATURA_NETTOPLAM,A.TOTALDISCOUNTS AS INDIRIM,E.CODE AS MUH_HESAP_KODU,E.DEFINITION_ AS MUH_HESAP_TANIMI,C.VATINC AS KDV_DAHILHARIC

FROM LG_211_01_INVOICE A, LG_211_CLCARD B,LG_211_01_STLINE C,LG_211_ITEMS D,LG_211_EMUHACC E
WHERE
(A.GRPCODE=1)
AND A.DATE_ BETWEEN '01.01.2010 00:00:00.000' AND '12.31.2010 23:59:59.999'
AND A.CLIENTREF=B.LOGICALREF
AND A.LOGICALREF=C.INVOICEREF
AND C.STOCKREF=D.LOGICALREF
AND C.LINETYPE in (0)
AND A.TRCODE IN (1,13)
AND A.CANCELLED=0
AND C.ACCOUNTREF=E.LOGICALREF
GROUP BY A.CYPHCODE,A.GRPCODE,A.FICHENO,A.DOCODE,C.STFICHELNNO,B.CODE,B.DEFINITION_,B.TAXNR,B.TAXOFFICE,D.CODE,D.NAME,C.AMOUNT,C.PRICE,C.VAT,C.LINENET,A.TOTALDISCOUNTS,A.DATE_,C.PRCURR,C.PRPRICE,C.VATMATRAH,C.VATAMNT,E.CODE,C.VATINC,E.DEFINITION_

UNION ALL

 -------------------------------------------------------------------------------------------------

SELECT 'ALINAN HİZMET',
A.DATE_,A.CYPHCODE,A.GRPCODE,C.INVOICELNNO,A.FICHENO,A.DOCODE,B.CODE,B.DEFINITION_,B.TAXNR,B.TAXOFFICE,D.CODE,D.DEFINITION_,C.AMOUNT,C.PRICE,(CASE C.PRCURR WHEN 0 THEN 'TL' WHEN 1 THEN 'DOLAR' WHEN 20 THEN 'EURO' END) ,C.PRPRICE,C.VAT,C.VATMATRAH

,CASE WHEN D.CODE IN ('159.01.014','159.01.014') THEN C.VATMATRAH ELSE C.VATAMNT END
,C.LINENET,A.TOTALDISCOUNTS,E.CODE,E.DEFINITION_,C.VATINC

FROM

LG_211_01_INVOICE A, LG_211_CLCARD B,LG_211_01_STLINE C,LG_211_SRVCARD D,LG_211_EMUHACC E

WHERE (A.GRPCODE=1)

AND A.DATE_ BETWEEN '01.01.2010 00:00:00.000' AND '12.31.2010 23:59:59.999'

AND A.CLIENTREF=B.LOGICALREF

AND A.LOGICALREF=C.INVOICEREF

AND C.STOCKREF=D.LOGICALREF

AND C.LINETYPE=4

AND C.ACCOUNTREF=E.LOGICALREF

AND A.CANCELLED=0

GROUP BY A.CYPHCODE,A.GRPCODE,C.INVOICELNNO,A.FICHENO,A.DOCODE,B.CODE,B.DEFINITION_,B.TAXNR,B.TAXOFFICE,B.TAXNR,B.TAXOFFICE,D.CODE,D.DEFINITION_,C.AMOUNT,C.PRICE,C.VAT,C.LINENET,A.TOTALDISCOUNTS,A.DATE_,C.VATMATRAH,C.VATAMNT,E.DEFINITION_,C.VATINC,C.PRCURR,C.PRPRICE,E.CODE

 -------------------------------------------------------------------------------------------------

UNION ALL
SELECT 'KASA HİZMET',
A.DATE_,A.CYPHCODE,A.GRPCODE,C.INVOICELNNO,A.FICHENO,A.DOCODE,'','','','',D.CODE,D.DEFINITION_,C.AMOUNT,C.PRICE,(CASE C.PRCURR WHEN 0 THEN 'TL' WHEN 1 THEN 'DOLAR' WHEN 20 THEN 'EURO' END) ,C.PRPRICE,C.VAT,C.VATMATRAH,C.VATAMNT,C.LINENET,A.TOTALDISCOUNTS,E.CODE,E.DEFINITION_,C.VATINC

FROM

LG_211_01_INVOICE A,LG_211_01_STLINE C,LG_211_SRVCARD D,LG_211_EMUHACC E

WHERE (A.GRPCODE=1)

AND A.DATE_ BETWEEN '01.01.2010 00:00:00.000' AND '12.31.2010 23:59:59.999'

AND A.LOGICALREF=C.INVOICEREF

AND C.STOCKREF=D.LOGICALREF

AND C.LINETYPE=4

AND C.ACCOUNTREF=E.LOGICALREF

AND A.CANCELLED=0

AND C.CLIENTREF=0

GROUP BY A.CYPHCODE,A.GRPCODE,C.INVOICELNNO,A.FICHENO,A.DOCODE,D.CODE,D.DEFINITION_,C.AMOUNT,C.PRICE,C.VAT,C.LINENET,A.TOTALDISCOUNTS,A.DATE_,C.VATMATRAH,C.VATAMNT,E.DEFINITION_,C.VATINC,C.PRCURR,C.PRPRICE,E.CODE