[quote]
CREATE TABLE
ZX_TEST
(
ID INTEGER,
FNAME VARCHAR(30),
AGE INTEGER
);
CREATE TABLE
ZX_TEST2
(
ID INTEGER,
FNAME VARCHAR(50),
AGE INTEGER
);
[/quote]
CREATE TABLE
ZX_TEST
(
ID INTEGER,
FNAME VARCHAR(30),
AGE INTEGER
);
CREATE TABLE
ZX_TEST2
(
ID INTEGER,
FNAME VARCHAR(50),
AGE INTEGER
);
[/quote]
merge into zx_test2 T
using (select ID,FNAME,AGE from zx_test ) A
on T.id = A.id
when not matched then
insert (ID,FNAME,AGE)
values(A.ID,A.FNAME,A.AGE)