这个SQL语句怎么写？(0分)

H

holyszq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-19

• #1

从一个表移到另外一个表里
两个表的字段不一样
用Insert Into Table1 (.....) Select ... From Table2
现在我要在Insert 的时候
Table1 中要多几几个字段的内容如何做呢？比如要加入日期、工号等!
谢谢!!!

 

C

china_bug

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-19

• #2

insert into table1 (oldfield1,..,newfield1,.) select *,'NO1' as newfield1 from Table2

 

H

holyszq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-19

• #3

谢谢!!!china_bug