This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

觉得有些怪, 这个main字段和B表一点关系没有吗? anyway, 下面的句子能实现.

mjs(臭豆腐-在痛苦中挣扎)

SELECT a.main, b.sub, Sum(b.amount) AS SumOfamount
FROM a, b
GROUP BY a.main, b.sub

(#367561@0)
Last Updated: 2002-2-13
This post has been archived. It cannot be replied.

Report