简单的问题!全部的家当 (60分)

T

thefirstdz

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-02

• #1

我想求一个表的某个字段的和后放入别一个表中，怎么实现呀？
可以这样子吗??
query1.sql.text:='select sum(A) as a into (select * form 统计表 where 月份:yf) from 明细表';
query1.params.ParambyName('yf').value:=ComboBox2.text;
query1.open;

 

Q

qianwt

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-02

• #2

select sum(A) as a into 统计表 from 明细表

 

春

春意

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-02

• #3

同意楼上说法：
会自动生成“明细表”，如果有则覆盖！！
select A,sum(A) as a into 统计表 from 明细表

 

Y

yaya8163

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-02

• #4

[^]

 

S

sxqsxq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-02

• #5

insert 结果(结果字段)
select sum(统计字段)
from 源

 

T

thefirstdz

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-02

• #6

可以这样子吗??
query1.sql.text:='select sum(A) as a into (select * form 统计表 where 月份:yf) from 明细表';
query1.params.ParambyName('yf').value:=ComboBox2.text;
query1.open;

本人刚刚学，希望大家能多给点意见!

 

T

thefirstdz

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-02

• #7

to sxqsxq
edit 结果(结果字段) <-这样可以吗?
select sum(统计字段)
from 源

 

Q

qianwt

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-02

• #8

to thefirstdz
不可以>>>>query1.sql.text:='select sum(A) as a into (select * form 统计表 where 月份:yf) from 明细表';
query1.sql.text:='insert into 统计表(月份,a) select sum(A),:yf from 明细表';
query1.ExecSQL //重要