各位请帮忙(15分)

W

wangchengwu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-31

• #1

各位请帮忙
a是学生各门成绩表，其中有字段id(学号)，cj（成绩）(注：id字段有重复)
b是学生基本情况表，其中有字段id(学号)，xm（姓名）（注：id字段无重复）

下面是显示每一个学生的学号，姓名，以及平均分。调试不通过，请大家帮忙
with adoquery2 do
begin
close;
sql.Clear ;
sql.Add('SELECT distinct a.id,avg(a.cj),b.xm from a,b where a.id=b.id group by id');
open;
end;

 

D

dz2050

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-31

• #2

sql.Add('SELECT distinct a.id,avg(a.cj),b.xm from a,b where a.id=b.id
group by a.id'

 

W

wangchengwu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-31

• #3

谢谢，还是通过不了

 

C

coldew

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-25

• #4

select b.id, xm, c.cj from b,
(select id, avg(cj) as from a group by id) as c

 

5

52free

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-25

• #5

SELECT b.id,xm,avg(cj) from b jion a on b.id=a.id group by b.id