快点救救我吧?
adocommand1.CommandText:='insert into jfjl(tjbj,hh,hm,yf,dl,df,dhhm1,dhhm2,dhhm3)'+
'select tjbj,hh,hm,yf,sum(dl),sum(df),dhhm1,dhhm2,dhhm3 from khda group by tjbj';
,他提示hh,hm,yf,dhhm1,dhhm2,dhhm3错误.
group by tjbj,hh,hm,yf,dhhm1,dhhm2,dhhm3
这样统计不出问题但是我要求的是只能按照tjbj的字段统计,但其他字段(hh,hm,yf,dhhm1,dhhm2,dhhm3)还必须保留内容急.急急急急急急急