请教一条SQL语句(100分)

D

dedema

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-02

• #1

table1如下：
zgh xm bm jbgz zw dh
b001 张三 财务部 600.00 会计师 1398888
b002 李四 市场部 800.00 销售经理 1396666
................
table2的结构如下：
zgh xm bm jbgz bt jj sfgz
表为空的。
现在想把table1的zgh,xm,bm,jbgz 的所有记录全插到table2的对应字段中.
请教条sql语句。

 

A

aidren

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-02

• #2

1.不知道bt，jj，sfgz这几个字段能不能为空：
2.看看在样行不行？
with adoquery1 do
begin
close;
sql.clear;
sql.add('select * from table1');
open;
end;
while adoquery1.eof<>true do
begin
adotable2.append;
fieldbyname('zgh').value:=adoquery1.fieldbyname('zgh').value;
.
.
adotable2.post
adoquery1.next;
end;

 

K

KeepObject

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-02

• #3

insert into table2 select zgh,xm,bm,jbgz,0 as bt,0 as jj,0 as sfgz from table1

 

F

fxjpost

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-02

• #4

insert into table2(zgh , xm ,bm,jbgz, bt , jj ,sfgz)
select zgh,xm,bm,jbgz,zw,bt='' , jj='' ,sfgz=''
from table1

 

K

KeepObject

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-02

• #5

或：
insert into table2 (zgh,xm,bm,jbgz) select zgh,xm,bm,jbgz from table1

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-02

• #6

关键是后面几个字段怎么对应，用上面的方法就行了

 

D

dragonlee007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-02

• #7

[8D][8D][8D][8D][8D][8D][8D]
go
create view [red]dataview[/red]
as
select table1.zgh,table1.xm,table1.bm,table1.jbgz
from table1

go
INSERT INTO table2 (zgh,xm,bm,jbgz)
SELECT zgh,xm,bm,jbgz
FROM [red]dataview[/red]
[8D][8D][8D][8D][8D][8D][8D]

 

D

dedema

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-01-26

• #8

多人接受答案了。