This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 有没有SQL高手啊(大概中手就行了),HELP
-goodbaby(小宝);
2002-2-13
{587}
(#367531@0)
-
我的机子没装SQL,说一说我的SQL,你多试试吧select main,sub,sum(amount)
from A,B
group by main,sub
-antmm(沉没);
2002-2-13
{56}
(#367541@0)
-
觉得有些怪, 这个main字段和B表一点关系没有吗? anyway, 下面的句子能实现.SELECT a.main, b.sub, Sum(b.amount) AS SumOfamount
FROM a, b
GROUP BY a.main, b.sub
-mjs(臭豆腐-在痛苦中挣扎);
2002-2-13
{85}
(#367561@0)
-
right
-zjoy(Joy);
2002-2-13
(#367574@0)
-
Thank you guys!I got it!:)
-goodbaby(小宝);
2002-2-13
(#367614@0)