用insert into Table1 select * from T2 ?
解决方案 »
- Delphi + win7+CY68013+ 读写USB
- socket向服务器传送一个大概10K足有的文件....
- 怎样把某字段不相同的值各抽出来一个?
- 总共十票,做一个酒店管理系统去参加软件设计大赛,你投多少票?
- 请问:那位大虾能告诉我怎样将下载来的ehlib2.5安装到我的delphi6上去,谢谢!!
- 关于showmessage
- 条码编程..................谁曾经做过
- ListView更改标题栏的问题。
- 对于字符串得判断可以用CASE吗?
- 简单!如何把一个COMBOBOX和LISTBOX中的数据全部取出来?谢谢!
- 用Delphi中的Database Desktop怎样插入一个新的字段在表中
- 一个以时间段作为查询条件的问题?(在线等待)
select cloumn1,cloumn2...
from Table2 as b
where b.Code_No not in(select Code_No from Table1)
sql1="select * from 表1"
rs1.open sql1 ,con,1,3
sql="select * from 表2"
rs.open sql ,con,1,3
do while(not rs.eof)
rs1.addnew
rs1("a")=rs("a")
...
rs1.update
rs.movenext
loop
rs.close
rs1.close
begin
close;
sql.Clear;
sql.Add('delete from fee_temp');
execsql;
//-----------------------------------------清空fee_temp表-----------------
close;
sql.Clear;
sql.Add('insert into fee_temp ');
sql.Add('select * from fee where (Pay_Is=true) and (Pay_Acman='''+op+''') and (Pay_Date>=:ss) and (Pay_Date<=:ee)');
parameters[0].Value:=timestart;
parameters[1].Value:=timeend;
execsql;
//-----------------------------------------从fee中选取记录-----------------
close;
sql.Clear;
sql.Add('insert into fee_temp ');
sql.Add('select * from fee_month where (Pay_Is=true) and (Pay_Acman='''+op+''') and (Pay_Date>=:ss) and (Pay_Date<=:ee)');
parameters[0].Value:=timestart;
parameters[1].Value:=timeend;
execsql;
//------------------------------------------从fee_month中选取记录-----------
close;
sql.Clear;
sql.Add('select * from fee_temp');
open;
end;//with dm.Qfee
with dm.Qyh do
begin
close;
sql.Clear;
sql.Add('select count(Yh_ID),sum(ele),sum(ele_Fee),sum(Late_Fee),sum(Sum_Fee) from fee_temp');
open;
end;
begin
close;
sql.Clear;
sql.Add('delete from fee_temp');
execsql;
//-----------------------------------------清空fee_temp表-----------------
close;
sql.Clear;
sql.Add('insert into fee_temp ');
sql.Add('select * from fee where (Pay_Is=true) and (Pay_Acman='''+op+''') and (Pay_Date>=:ss) and (Pay_Date<=:ee)');
parameters[0].Value:=timestart;
parameters[1].Value:=timeend;
execsql;
//-----------------------------------------从fee中选取记录-----------------
close;
sql.Clear;
sql.Add('insert into fee_temp ');
sql.Add('select * from fee_month where (Pay_Is=true) and (Pay_Acman='''+op+''') and (Pay_Date>=:ss) and (Pay_Date<=:ee)');
parameters[0].Value:=timestart;
parameters[1].Value:=timeend;
execsql;
//------------------------------------------从fee_month中选取记录-----------
close;
sql.Clear;
sql.Add('select * from fee_temp');
open;
end;//with dm.Qfee
with dm.Qyh do
begin
close;
sql.Clear;
sql.Add('select count(Yh_ID),sum(ele),sum(ele_Fee),sum(Late_Fee),sum(Sum_Fee) from fee_temp');
open;
end;