我现在有两个表fee(Feesum,CID,Tag)和course(CID,Cname),我现在写了一个sql语句:select CID,SUM(Feesum) AS feesum from fee where Tag=1 GROUP BY CID,结果正确显示出来了。可是这个语句只是对其中一个表进行了操作,我还想将course表的Cname也显示出来(已知fee.CID=course.CID),可是我用:select fee.CID,Cname,SUM(Feesum) AS feesum from fee,course where Tag=1 and course.CID=fee.CID GROUP BY CID执行的时候,运行结果是错的.谁能为我写个正确的出来啊?
select fee.CID,Cname,SUM(Feesum) AS feesum from fee,course where Tag=1 and course.CID=fee.CID GROUP BY CID,Cname
from fee,course where Tag=1 and course.CID=fee.CID
GROUP BY fee.CID,course.Cname
from fee,course where Tag=1 and course.CID=fee.CID
GROUP BY fee.CID