SQL句是SELECT附近？是不是SUM函面不嵌套SELECT句？
SELECT B002, SUM
(SELECT [B005] FROM
(SELECT * FROM TAICON_TB INNER JOIN
TAICON_TA INNER JOIN
INPUT_B INNER JOIN
INPUT_A ON INPUT_B.B001 = INPUT_A.A001 AND
INPUT_B.B006 = INPUT_A.A012 ON
TAICON_TA.TA001 = INPUT_B.B002 ON
TAICON_TB.TB002 = TAICON_TA.TA006
WHERE (TAICON_TB.TB003 = '5 ') AND (INPUT_A.A002 = '1 ')
AND (INPUT_A.A014 = '[3]207料待理品 '))
WHERE A008 LIKE '2007.1.% ') AS 本月存,
SUM
(SELECT [B005] FROM
(SELECT * FROM TAICON_TB INNER JOIN
TAICON_TA INNER JOIN

INPUT_B INNER JOIN
INPUT_A ON INPUT_B.B001 = INPUT_A.A001 AND
INPUT_B.B006 = INPUT_A.A012 ON
TAICON_TA.TA001 = INPUT_B.B002 ON
TAICON_TB.TB002 = TAICON_TA.TA006
WHERE (TAICON_TB.TB003 = '5 ') AND (INPUT_A.A002 = '1 ')
AND (INPUT_A.A014 = '[3]207料待理品 '))
WHERE A008 < '2007.1.00 ') AS 上月存
FROM (SELECT * FROM TAICON_TB INNER JOIN
TAICON_TA INNER JOIN
INPUT_B INNER JOIN
INPUT_A ON INPUT_B.B001 = INPUT_A.A001 AND
INPUT_B.B006 = INPUT_A.A012 ON
TAICON_TA.TA001 = INPUT_B.B002 ON

TAICON_TB.TB002 = TAICON_TA.TA006
WHERE (TAICON_TB.TB003 = '5 ') AND (INPUT_A.A002 = '1 ') AND (INPUT_A.A014 = '[3]207料待理品 '))T
GROUP BY B002

上面第是提示 "SELECT 附近的法不正 " 可是我拆出一行都是正的呀
是不是SUM函面不能嵌套SELECT句？

[解决办法]
看了好久看不出来。顶了。
[解决办法]
SELECT * FROM TAICON_TB INNER JOIN
TAICON_TA INNER JOIN
INPUT_B INNER JOIN
INPUT_A ON INPUT_B.B001 = INPUT_A.A001 AND
INPUT_B.B006 = INPUT_A.A012 ON
TAICON_TA.TA001 = INPUT_B.B002 ON
TAICON_TB.TB002 = TAICON_TA.TA006

--可以这样内联吗？

[解决办法]
而且子查询中的结果要取别名
[解决办法]
先优化你的sql，这样的sql谁看着都头疼，以后谁都不敢接手你的程序了