试试这个吧 with query1 do begin close; sql.clear; SQL.Add('Insert Into "Temp.db" Select'); SQL.Add('A.DEBH,A.CLBH,B.CLMC,B.CLDW,A.CLHL,B.CLDJ,B.CLLB'); SQL.Add('From "表1" A,"表2" B'); ExecSQL; end;
From 后面加上条件不就行了吗
for i:=0 to query1.fieldcount-1 do begin for j:=0 to query2.fieldcount-1 do begin if query1.fields[i].fieldname=query2.fields[j].fieldname then query1.fields[i].value:=query2.fields[j].value; end; end;试一试吧,应该可以。
with query1 do
begin
close;
sql.clear;
SQL.Add('Insert Into "Temp.db" Select');
SQL.Add('A.DEBH,A.CLBH,B.CLMC,B.CLDW,A.CLHL,B.CLDJ,B.CLLB');
SQL.Add('From "表1" A,"表2" B');
ExecSQL;
end;
begin
for j:=0 to query2.fieldcount-1 do
begin
if query1.fields[i].fieldname=query2.fields[j].fieldname then
query1.fields[i].value:=query2.fields[j].value;
end;
end;试一试吧,应该可以。