请问下各位下面这句SQL那里不对啊??
SELECT sum(MOCTE.TE005) FROM MOCTE
INNER JOIN (select TA001,TA002 from MOCTA where TA006='SA1000454100') MA ON MOCTE.TE011 = MA.TA001 AND MOCTE.TE012 = MA.TA002
INNER JOIN (select TD013,TD021 from PURTD where PURTD.TD013 LIKE'51%' and PURTD.TD004='SA2820273201') PT ON PT.TD013=MOCTA.TA001 and PT.TD021=MOCTA.TA002
SELECT sum(MOCTE.TE005) FROM MOCTE
INNER JOIN (select TA001,TA002 from MOCTA where TA006='SA1000454100') MA ON MOCTE.TE011 = MA.TA001 AND MOCTE.TE012 = MA.TA002
INNER JOIN (select TD013,TD021 from PURTD where PURTD.TD013 LIKE'51%' and PURTD.TD004='SA2820273201') PT ON PT.TD013=MOCTA.TA001 and PT.TD021=MOCTA.TA002
sum(MOCTE.TE005)
FROM
MOCTE
INNER JOIN
(select TA001,TA002 from MOCTA where TA006='SA1000454100') MA ON
MOCTE.TE011 = MA.TA001 AND MOCTE.TE012 = MA.TA002
INNER JOIN
(select TD013,TD021 from PURTD where PURTD.TD013 LIKE'51%' and PURTD.TD004='SA2820273201') PT ON
PT.TD013=MOCTA.TA001 and PT.TD021=MOCTA.TA002
FROM MOCTE
INNER JOIN
(
select TA001,TA002 from MOCTA where TA006='SA1000454100'
)
MA
ON
MOCTE.TE011 = MA.TA001 AND MOCTE.TE012 = MA.TA002
INNER JOIN
(
select TD013,TD021 from PURTD where PURTD.TD013 LIKE'51%' and PURTD.TD004='SA2820273201'
)
PT
ON PT.TD013=MOCTA.TA001 and PT.TD021=MOCTA.TA002