循环保存的问题

[sisiz]

从一个表TB里查询到一个或多个记录
select pid from tb where rid=@rID
查询出来的结果是一个多个pid
然后我再把这个多个pic 追加到其他TB2 表里，怎么做呢

[csdyyr]

select pid into TB2 from tb where rid=@rID 

[hyde100]

insert into TB2
select pid from tb where rid=@rID 

[csdyyr]

insert TB2(col)
select pid from tb where rid=@rID 

[水族杰纶]

insert tb2(字段)select pid from tb where rid=@rID 

[hyde100]

如果TB2里字段也叫pid

insert into TB2(pid)
select pid from tb where rid=@rID

[sisiz]

TB2表里多个自动ID，不行啊

[水族杰纶]

[Quote=引用 6 楼 sisiz 的回复:]
TB2表里多个自动ID，不行啊
[/Quote]

--如果PID 在tb中也是自增
insert tb2(字段)select pid*1 from tb where rid=@rID