2,498
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO AntiqueOwners ( OwnerID, OwnerLastName, OwnerFirstName )
SELECT EmployeeIDNo, LastName, FirstName
FROM EmployeeAddressTab
le
WHERE City='Upton'
ADOQuery1.close;
ADOQuery1.SQL.clear;
ADOQuery1.SQL.add('insert into table (字段) select 字段 from table2 where 条件');
ADOQuery1.Execsql