procedure TForm1.Button1Click(Sender: TObject);
var
str :string;
beginadoquery1.Close;
adoquery1.sql.clear;
str:='insert into a_lwb2 '
+ 'select zybak.bah '
+ 'cyzdk.lx '
+ 'sszdk.dm '
+ 'from zybak,cyzdk,sszdk where '
+ 'zybak.zyh=cyzdk.zyh and sszdk.zyh=zybak.zyh and zybak.zyh =sszdk.zyh ';
adoquery1.SQL.add('''+str+''');adoquery1.ExecSQL ;
showmessage('ok'); end;
end.正在学习中,请大家帮助一下
var
str :string;
beginadoquery1.Close;
adoquery1.sql.clear;
str:='insert into a_lwb2 '
+ 'select zybak.bah '
+ 'cyzdk.lx '
+ 'sszdk.dm '
+ 'from zybak,cyzdk,sszdk where '
+ 'zybak.zyh=cyzdk.zyh and sszdk.zyh=zybak.zyh and zybak.zyh =sszdk.zyh ';
adoquery1.SQL.add('''+str+''');adoquery1.ExecSQL ;
showmessage('ok'); end;
end.正在学习中,请大家帮助一下
var
str :string;
beginadoquery1.Close;
adoquery1.sql.clear;
str:='insert into a_lwb2 '
+ 'select zybak.bah '
+ ',cyzdk.lx '
+ ',sszdk.dm '
+ 'from zybak join cyzdk on zybak.zyh=cyzdk.zyh '
+ 'join sszdk on sszdk.zyh=zybak.zyh ';
adoquery1.SQL.add(str);adoquery1.ExecSQL ;
showmessage('ok'); end;
end.按上更改试试。
insert into t select A,B,C,D from t1