易飞工单几个SQL

SELECT TB001,TB002,TB014,MB002,MB003,TA015,MB004,TB003,TB012,TB013,
TB004 as 需领用量 ,MB064,MB064-(TB004-TB005) AS 欠料,TB005 as 已领用量,PURING,TB007 
FROM MOCTB
LEFT JOIN INVMB ON MB001=TB014
LEFT JOIN MOCTA ON TA001=TB001 AND TA002=TB002
LEFT JOIN (SELECT A.TD004,SUM(未交数量) AS PURING FROM
(SELECT   TD001,TD002,TD004,TD005,TD006,TD009,TD008,TD015,TD008-TD015 AS 未交数量 FROM PURTD
WHERE TD016='N' ) A GROUP BY A.TD004) B ON TB003=TD004
WHERE TB018='Y'  AND TB011='1'
AND TA011 IN('1','2','3') AND TA030='1' AND TA013='Y' AND MB064-(TB004-TB005)<0

order by TB001,TB002

SELECT TA021,MD002,TA001,TA002,TA003,--TA011,
TA006,TA034,TA035,TA007,TA009,TA010,TA012,TA014,
TA015,TA016,TA017,TA018 FROM MOCTA 
LEFT JOIN CMSMD ON TA021=MD001
WHERE TA011 IN('1','2','3') AND TA030='1' AND TA013='Y'
AND TA021='005' 

SELECT TB001,TB002,TB014,MB002,MB003,TA015,MB004,TB003,TB012,TB013,TB004 as 需领用量 ,TOTO,TOTO-(TB004-TB005) AS 欠料,TB005 as 已领用量,TB007 FROM MOCTB
LEFT JOIN INVMB ON MB001=TB014
LEFT JOIN (SELECT A.MC001,SUM(A.MC007) TOTO from INVMC A
LEFT JOIN CMSMC C ON C.MC001=A.MC002 GROUP BY A.MC001) DD ON DD.MC001=TB014
LEFT JOIN MOCTA ON TA001=TB001 AND TA002=TB002
WHERE TB018='Y'  AND TB011='1'
AND TA011 IN('1','2','3') AND TA030='1' AND TA013='Y' AND TB004>TB005
order by TB001,TB002
--AND TA021='005'