请问在 access2003中 4个表以上包括4个表的连接语句应该怎么些啊！谢谢！

[diablofriend]

请问在 access中 4个表以上包括4个表的连接语句应该怎么些啊！谢谢！
希望能够举个四个表的例子 ，还有5个表的例子！谢谢了！

[diablofriend]

第一个表和第二个表内连，和第三第四个表左联！谢谢！

[wwwwb]

示例，自己更改
select * from ((a left join b on a.f1=b.f1) left join c
on a.f1=c.f1) left join d on a.f1=d.f1

[diablofriend]

请大家帮忙看看这个sql语句哪里还有问题啊！


SELECT JanCd, MAX(SH.ShName) AS ShName, SUM(ST.Hachusu) AS Hachusu, SUM(ST.Hikiatesu) AS Hikiatesu,
SUM(ST.Syukasu) AS Syukasu, SUM(ST.Kepinsu) AS Kepinsu
FROM (
SELECT
ST.JanCd,
SH.ShName,
ST.Hachusu,
ST.Hikiatesu,
ST.Syukasu,
ST.Kepinsu
FROM (CT_Denpyo DT
INNER JOIN CT_Syohin ST
ON DT.RecvDate= ST.RecvDate
AND DT.RecvCnt = ST.RecvCnt
AND DT.StCd = ST.StCd
AND DT.TkCd = ST.TkCd
AND DT.TenpoCd = ST.TenpoCd
AND DT.DenNo = ST.DenNo)
LEFT JOIN CT_Shconv SH
ON ST.StCd = SH.StCd
AND ST.TkCd = SH.TkCd
AND ST.JanCd = SH.JanCd
LEFT JOIN CT_Zaiko ZT
ON SH.SHCd = ZT.SHCd
WHERE DT.StCd = 3100
AND DT.TkCd = 44152
AND DT.Nohinbi = '20070924'
AND DT.Syukabi = '20070924'
) AS wk1 GROUP BY JanCd
ORDER BY JanCd

[wwwwb]

ELECT JanCd, MAX(SH.ShName) AS ShName, SUM(ST.Hachusu) AS Hachusu, SUM(ST.Hikiatesu) AS Hikiatesu,
SUM(ST.Syukasu) AS Syukasu, SUM(ST.Kepinsu) AS Kepinsu
FROM (
SELECT
ST.JanCd,
SH.ShName,
ST.Hachusu,
ST.Hikiatesu,
ST.Syukasu,
ST.Kepinsu
FROM ((CT_Denpyo DT
INNER JOIN CT_Syohin ST ON DT.RecvDate= ST.RecvDate AND DT.RecvCnt = ST.RecvCnt AND DT.StCd = ST.StCd AND DT.TkCd = ST.TkCd
AND DT.TenpoCd = ST.TenpoCd
AND DT.DenNo = ST.DenNo)
LEFT JOIN CT_Shconv SH
ON ST.StCd = SH.StCd
AND ST.TkCd = SH.TkCd
AND ST.JanCd = SH.JanCd)
LEFT JOIN CT_Zaiko ZT
ON SH.SHCd = ZT.SHCd
WHERE DT.StCd = 3100
AND DT.TkCd = 44152
AND DT.Nohinbi = '20070924'
AND DT.Syukabi = '20070924')
AS wk1 GROUP BY JanCd
ORDER BY JanCd

[wwwwb]

sELECT JanCd, MAX(SH.ShName) AS ShName, SUM(ST.Hachusu) AS Hachusu, SUM(ST.Hikiatesu) AS Hikiatesu,
SUM(ST.Syukasu) AS Syukasu, SUM(ST.Kepinsu) AS Kepinsu
FROM (
SELECT
ST.JanCd,
SH.ShName,
ST.Hachusu,
ST.Hikiatesu,
ST.Syukasu,
ST.Kepinsu
FROM ((CT_Denpyo DT
INNER JOIN CT_Syohin ST ON DT.RecvDate= ST.RecvDate AND DT.RecvCnt = ST.RecvCnt AND DT.StCd = ST.StCd AND DT.TkCd = ST.TkCd
AND DT.TenpoCd = ST.TenpoCd
AND DT.DenNo = ST.DenNo)
LEFT JOIN CT_Shconv SH
ON ST.StCd = SH.StCd
AND ST.TkCd = SH.TkCd
AND ST.JanCd = SH.JanCd)
LEFT JOIN CT_Zaiko ZT
ON SH.SHCd = ZT.SHCd
WHERE DT.StCd = 3100
AND DT.TkCd = 44152
AND DT.Nohinbi = '20070924'
AND DT.Syukabi = '20070924')
AS wk1 GROUP BY JanCd
ORDER BY JanCd

[diablofriend]

哈哈知道了，要来是少个括弧！谢谢您了！分不多但是真的很感谢您！