怎么进行三个表的联合查询？

[tanrui]

可以用join对三个表进行联合查询吗？
谢谢

[guolibin]

WHERE A.COL1=B.COL1
AND B.COL1=C.COL1
AND C.COL1=A.COL1

[tanrui]

那join语句应该怎么写？？

[guolibin]

这里有个sql server 2000 的例子：
SELECT A.UserId, A.UserName, A.Area, A.wId AS TableId, A.wNO AS TableNo, B.pNO,
B.YearMonth, B.PreNum, B.CurrNum, B.UseNum, B.TheMoney, B.ZhiNaJin,
B.PayMoney, B.ToPreMoney, B.Finish, B.FreeMoney, C.pNo AS PayNo, C.PaySeq,
C.PayType, C.PayNum, C.ToPreMoney AS ToPreMoney2, C.FaPiaoNo, C.Collector,
C.ColTime, C.IsDel
FROM tWaterTable A INNER JOIN
tUseWaterInfo B ON A.wId = B.TableId INNER JOIN
tPayInfo C ON B.pNO = C.PayFor

[guolibin]

这是在Access 中的：
SELECT
A.UserId, A.UserName, A.Area, A.wId AS [TableId], A.wNO AS TableNo,
B.pNO, B.YearMonth, B.PreNum, B.CurrNum, B.UseNum, B.TheMoney, B.ZhiNaJin,
B.PayMoney, B.ToPreMoney, B.Finish, B.FreeMoney, C.pNo AS PayNo,
C.PaySeq, C.PayType, C.PayNum, C.ToPreMoney AS ToPreMoney2, C.FaPiaoNo,
C.Collector, C.ColTime, C.IsDel
FROM
(tWaterTable AS A INNER JOIN tUseWaterInfo AS B ON A.wId = B.TableId)
INNER JOIN tPayInfo AS C ON B.pNO = C.PayFor;