insert into t3 select t2.projectid,t1.name,t1.age,t2.time where t1.id=t2.clientid
insert into t3 select t2.projectid,t1.name,t1.age,t2.time from t1 ,t2 where t1.id=t2.clientid
insert into t3 select t2.projectid,t1.name,t1.age,t2.time from t1,t2 where t1.id=t2.clientid
insert into t3 select t2.projectid,t1.name,t1.age,t2.time from t1 inner join t2 on t1.id=t2.clientid and PROJECTID in('003','007')
or insert into t3 select t2.projectid,t1.name,t1.age,t2.time from t1 ,t2 where t1.id=t2.clientid and PROJECTID in('003','007')
insert into t3 select b.PROJECTID,a.name,a.age,b.time from t1 a,t2 b where a.ID=b.CLIENTID
如果你要指定几条记录可以这样:select identity(int,1,1) IDD,t2.projectid Projectid,t1.name Name,t1.age Age,t2.time Time into #T from t1,t2 where t1.id=t2.clientid insert into t3 select progectid,name,age,Time where idd between 3 and 7 --将第三条至第七条的记录送到t3里
如果T3表不存在,就用: select b.PROJECTID,a.name,a.age,b.time into t3 from t1 a,t2 b where a.ID=b.CLIENTID
select t2.projectid,t1.name,t1.age,t2.time
from t1 ,t2
where t1.id=t2.clientid
select t2.projectid,t1.name,t1.age,t2.time
from t1 inner join t2 on t1.id=t2.clientid and PROJECTID in('003','007')
insert into t3
select t2.projectid,t1.name,t1.age,t2.time
from t1 ,t2
where t1.id=t2.clientid and PROJECTID in('003','007')
select b.PROJECTID,a.name,a.age,b.time
from t1 a,t2 b
where a.ID=b.CLIENTID
insert into t3 select progectid,name,age,Time where idd between 3 and 7 --将第三条至第七条的记录送到t3里
select b.PROJECTID,a.name,a.age,b.time
into t3
from t1 a,t2 b
where a.ID=b.CLIENTID