根据每个表的重复的ID字段把表a的字段a1和a2,表b字段b1和b2,表c的字段c1和c2合并,并且表a的ID=表b的ID=表c的ID=表D的ID,最后根据表D的ID把结果显示出来。

不知道我说的明白吗？

大家帮忙看看

表a 表b 表c
ID a1 a2 ID b1 b2 ID c1 c2
001 100 150 001 200 250 001 10 20
002 150 200 002 150 200 002 20 30
001 50 60 002 100 100 003 30 40
003 10 10 003 50 50 003 50 50
ID=表D的ID的查询出来
结果像这样：
ID a1 a2 b1 b2 c1 c2
001 150 210 200 250 10 20
002 150 200 250 300 20 30
003 20 20 50 50 80 90

这回应该很清楚了

[此贴子已经被作者于2007-1-10 13:07:45编辑过]

不好意思，写错了，谢谢提醒！
你知道应该怎么写吗？

select ItemInfo.ItemID,ItemInfo.ItemName,aa.SePaMo,aa.SeInMo,aa.SeFaMo,bb.StoPaMo,bb.StoInMo,bb.StoCoMo,ItemInfo.Itemys,bb.StoPaMo,cc.CoDeSt,cc.CoStock,bb.StoEsMo,cc.CoCost from ItemInfo,
(select SeItem,sum(SePaMo) as SePaMo ,sum(SeInMo) as SeInMo,sum(SeFaMo) as SeFaMo from SePactInfo group by SeItem) as aa,
(select StoItem,sum(StoPaMo) as StoPaMo ,sum(StoInMo) as StoInMo,sum(StoCoMo) as StoCoMo,sum(StoEsMo) as StoEsMo from StoPactInfo group by StoItem) as bb ,
(select CoItem,sum(CoDeSt) as CoDeSt ,sum(CoStock) as CoStock,sum(CoCost) as CoCost from CoSellInfo group by CoItem) as cc where ItemInfo.ItemName=aa.SeItem and ItemInfo.ItemName=bb.StoItem and ItemInfo.Item=cc.CoItem

大哥我照你那个改的可是为什么查不出数据来啊，是不是那里错了阿？

ItemInfo有5个字段Item,ItemID,ItemName,Principal,Itemys
我写的语法还没有错啊

[此贴子已经被作者于2007-1-10 14:03:31编辑过]

select ItemInfo.ItemID,ItemInfo.ItemName,aa.SePaMo,aa.SeInMo,aa.SeFaMo,bb.StoPaMo,bb.StoInMo,bb.StoCoMo,ItemInfo.Itemys,bb.StoPaMo,cc.CoDeSt,cc.CoStock,bb.StoEsMo,cc.CoCost from ItemInfo,
(select SeItem,sum(SePaMo) as SePaMo ,sum(SeInMo) as SeInMo,sum(SeFaMo) as SeFaMo from SePactInfo group by SeItem) as aa,
(select StoItem,sum(StoPaMo) as StoPaMo ,sum(StoInMo) as StoInMo,sum(StoCoMo) as StoCoMo,sum(StoEsMo) as StoEsMo from StoPactInfo group by StoItem) as bb ,
(select CoItem,sum(CoDeSt) as CoDeSt ,sum(CoStock) as CoStock,sum(CoCost) as CoCost from CoSellInfo group by CoItem) as cc where ItemInfo.ItemName=aa.SeItem and ItemInfo.ItemName=bb.StoItem and ItemInfo.Item=cc.CoItem

这里错了，应该是ItemName
大哥谢谢你了

还有你的头像可真强