我想用以下SQL语句,将多条相同记录汇总成一条,并添加至另一表中.(即在记录中凡是course,course_id,textbook,edittion,author,publisher字段相同的,txtnum、exercisenum、revi_filenum相加,)
procedure TForm1.BitBtn1Click(Sender: TObject);
begin
F_DM2.ClientDataSet1.Close;
F_DM2.ClientDataSet1.CommandText:= select id,class_id,class_master,class_name,course,course_id,textbook,edittion,
author,publisher,sum(txtnum) as txtno ,sum(exercisenum) as texno,sum(revi_filenum) as trevno into texlist
from clsoder group by course,course_id,textbook,edittion,author,publisher;
F_DM2.ClientDataSet1.Excute;
F_DM2.ClientDataSet1.Open;
F_DM2.ClientDataSet1.Refresh;
end;
end.
1、出错:Undeclared identitier:'select'。什么意思?难道select语句也要声明。
2、其他地方有错的吗?请帮修改一下。非常感谢!
procedure TForm1.BitBtn1Click(Sender: TObject);
begin
F_DM2.ClientDataSet1.Close;
F_DM2.ClientDataSet1.CommandText:= select id,class_id,class_master,class_name,course,course_id,textbook,edittion,
author,publisher,sum(txtnum) as txtno ,sum(exercisenum) as texno,sum(revi_filenum) as trevno into texlist
from clsoder group by course,course_id,textbook,edittion,author,publisher;
F_DM2.ClientDataSet1.Excute;
F_DM2.ClientDataSet1.Open;
F_DM2.ClientDataSet1.Refresh;
end;
end.
1、出错:Undeclared identitier:'select'。什么意思?难道select语句也要声明。
2、其他地方有错的吗?请帮修改一下。非常感谢!
author,publisher,sum(txtnum) as txtno ,sum(exercisenum) as texno,sum(revi_filenum) as trevno into texlist
from clsoder group by course,course_id,textbook,edittion,author,publisher’;