SELECT SUM(B.SCORE1), SUM(B.SCORE2),
B.NUM FROM MASTER A, STUDENT B
WHERE A.ID = B.NUM AND B.SEX = '1' AND B.CLASS= '0001' GROUP BY B.NUM
B.NUM FROM MASTER A, STUDENT B
WHERE A.ID = B.NUM AND B.SEX = '1' AND B.CLASS= '0001' GROUP BY B.NUM
B.NUM FROM MASTER A, STUDENT B
WHERE A.ID = B.NUM AND B.SEX = '1' AND B.CLASS= '0001' GROUP BY A.NAME,B.NUM
SELECT SUM(B.SCORE1), SUM(B.SCORE2), A.NAME,
B.NUM FROM MASTER A, STUDENT B
WHERE A.ID = B.NUM AND B.SEX = '1' AND B.CLASS= '0001' GROUP BY A.NAME
这样也还是抱错啊
B.NUM FROM MASTER A, STUDENT B
WHERE A.ID = B.NUM AND B.SEX = '1' AND B.CLASS= '0001' GROUP BY A.NAME,B.NUM谢谢大家 :)
SELECT SUM(B.SCORE1), SUM(B.SCORE2),
B.NUM,A.NAME FROM MASTER A, STUDENT B
WHERE A.ID = B.NUM AND B.SEX = '1' AND B.CLASS= '0001' GROUP BY B.NUM
这样可以吗,希望楼主能告知试验结果。