求一SQL 语句,请各位帮帮忙!(100分)

A

abcls

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-01-22

• #1

有两个表TABLE1,TABLE2,两个表中都有CardNo字段,我现在想把所有在TABLE2中的CardNo,并且Table1中不存在的记录,插入到Table1中,只要一条SQL 语句来完成,这语句该如何写呢?

 

S

starluck

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-01-22

• #2

insert into table 1 <br>&nbsp;select * from table2 where cardno not in (select cardno from table1)<br>具体中间的字段你来写

 

S

smilyvm

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-01-22

• #3

insert into table1 <br>select * from table2 where CardNo not in(select CardNo from table1)

 

L

laiaseven

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-01-22

• #4

insert table1 (cardno) select a.cardno from table2 a join <br>&nbsp; &nbsp; &nbsp; &nbsp; table1 b join table2 c on b.cardno&lt;&gt;c.cardno <br>&nbsp; &nbsp; on a.cardno=c.cardno

 

C

Corn3

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-01-22

• #5

insert into table 1 <br>select * from table2 where not (cardno in (select cardno from table1))<br><br>第一次可以这样插。以后的话，可以在Table2表中加一个字段，用来表示这条记录是否是新添加的。然后与Table1同步的时候，可以不用这样遍历一遍，而直接根据这个字段来，如果是新的就直接更新到Table1上。更新完了再更新这个标志字段。

 

A

abcls

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-01-22

• #6

多人接受答案了。