【【【【简单的插入表的问题】】】】

[噯卟釋手]

[b]表t1、t2
----------------------------------------------
t1:有很多usercode u01、u02、u03、、、、

usercode (用户)

u01
u02
u03
u04
----------------------------------------------
t2:已经有一个usercode:u01

usercode userflag

u01 aa
u01 bb
u01 cc
u01 dd
----------------------------------------------
怎么循环把t1里其他剩下的usercode插入到t2里？

规则就是每一个usercode也要有u01的那些userflag

在线等。。。。。。。。。。[/b]

[噯卟釋手]

有人来帮忙先吱一声撒

[dawugui]

insert into t2 select t1.usercode, t2.userflag from t1 , t2 where t1.usercode <> 'u01'

[lcw321321]

insert into t2 select t1.* from t2 left jion t1 on a.usercode=b.usercode where t1.userflag is null

不明白楼主的意思,帮顶

[王向飞]

[Quote=引用 2 楼 dawugui 的回复:]

insert into t2 select t1.usercode, t2.userflag from t1 , t2 where t1.usercode <> 'u01'
[/Quote]这样会不会死循环了？

[dawugui]

create table t1(usercode varchar(10))
insert into t1 values('u01')
insert into t1 values('u02')
insert into t1 values('u03')
insert into t1 values('u04')
create table t2(usercode varchar(10),userflag varchar(10))
insert into t2 values('u01', 'aa')
insert into t2 values('u01', 'bb')
insert into t2 values('u01', 'cc')
insert into t2 values('u01', 'dd')
go

insert into t2 select t1.usercode, t2.userflag from t1 , t2 
where t1.usercode <> 'u01' and t2.usercode = 'u01'

select * from t2 order by usercode ,userflag

drop table t1 , t2

/*
usercode   userflag   
---------- ---------- 
u01        aa
u01        bb
u01        cc
u01        dd
u02        aa
u02        bb
u02        cc
u02        dd
u03        aa
u03        bb
u03        cc
u03        dd
u04        aa
u04        bb
u04        cc
u04        dd

（所影响的行数为 16 行）

*/

[噯卟釋手]

简单说就是 把u02 的 aa bb cc dd 也插入到t2撒 u03、u04、u05类似、、、、

[噯卟釋手]

哇 高手一来 问题迎刃而解！

[噯卟釋手]

我喜欢数据库板块！

[王向飞]

我喜欢MM

[liudeqing2008]

insert into t2 select t1.usercode, t2.userflag from t1 , t2 where t1.usercode not in (select t2.usercode from t2)