是SQL句嵌套。
SQL句一:
SELECT * FROM TAICON_TB JOIN
TAICON_TA JOIN
INPUT_B 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
(TAICON_TA.TA001 LIKE 'TA% ') AND
(INPUT_A.A014 = '[3]207 料待理品 ')
上面的果得出:
原表
TB001 TB002 TB003 TA001 TA002 .. TA007 B001 B002 .. B005 A001 A002 .. A014
... ... ... TAQ01 ... .. ... .. TAQ01.. 2300 2006.11.02
... ... ... TAQ13 ... .. ... .. TAQ13.. 2500 2006.11.15
... ... ... TAQ21 ... .. ... .. TAQ21.. 4200 2006.12.10
... ... ... TAQ35 ... .. ... .. TAQ35.. 5200 2006.12.16

上面
TA001 品
B002 也是品，是另一表合在一起的
B005 是 量
A002 是 日期

SQL句二:
SELECT B005 FROM TAICON_TB JOIN
TAICON_TA JOIN
INPUT_B 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_A001 < '2006.12.00 ')
(TAICON_TA.TA001 LIKE 'TA% ') AND
(INPUT_A.A014 = '[3]207 料待理品 ')
上面的果得出:
TA001 | B005
-------------
TAQ01 2300
TAQ12 2500
... ...

在怎在用一SQL句上面的句在一起，算出上月存和本月存
我如果用

Select TA001,sum(SQL句一) from (SQL句二) Group by TA001

上面句代入的，提示SELECT句附近？能不能嵌套呢？


[解决办法]
沙.........
[解决办法]
SELECT A.* ,B.B005 AS NEWB005 FROM
(SELECT B005 FROM TAICON_TB JOIN
TAICON_TA JOIN
INPUT_B 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_A001 < '2006.12.00 ')
(TAICON_TA.TA001 LIKE 'TA% ') AND
(INPUT_A.A014 = '[3]207 料待理品 ')
) A INNER JOIN (SELECT TA001,B005 FROM TAICON_TB JOIN
TAICON_TA JOIN
INPUT_B 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_A001 < '2006.12.00 ')
(TAICON_TA.TA001 LIKE 'TA% ') AND
(INPUT_A.A014 = '[3]207 料待理品 '))B
ON A.TA001=B.TA001

[解决办法]
Select TA001,sum(SQL句一)
from
(
SQL句二
)as re
Group by TA001

[解决办法]
有
[解决办法]
楼主,这个是不中和另两个贴是一样的