insert table1(zd1,zd2) select zz,dd from table2 a,table3 b where a.关键字段=b.关键字段
Table2和Table3有啥关联关系啊? insert table1(zd1,zd2) select zz,dd from table2 a,table3 b where a.关键字段=b.关键字段
insert table1(zd1,zd2) select zz,dd from( select px=row_number()over(order by getdate()),zz from table2)a full join ( select px=row_number()over(order by getdate()),dd from table3)b on a.px=b.px
insert into table1(zd1) select zz from table2insert into table1(zd2) select dd from table3
抱歉,前面可能没讲清楚,我自己也搞的晕了 数据库是access2010table1(id,zd1,zd2) (id自增) table2(tt,zz) table3(kk,dd)zd1 = (SELECT zz FROM table2 WHERE tt='asd') 查出的结果只有1个 zd2 = (SELECT dd FROM table3 WHERE kk='jkl') 查出的结果只有1个INSERT INTO table1(zd1,zd2) ...大致过程如上 我试了几种方法都插不进数据,不知道问题出在哪里 目前还没解决,求助求助。。
update table1 set zd1=(SELECT zz FROM table2 WHERE tt='asd') update table1 set zd2 = (SELECT dd FROM table3 WHERE kk='jkl')
insert table1(zd1,zd2) select zz,dd from( select px=row_number()over(order by getdate()),zz from table2)a full join ( select px=row_number()over(order by getdate()),dd from table3)b on a.px=b.px--这个你确定试过了?
试过,不对INSERT INTO table1(zd1,zd2) SELECT zz,dd FROM table2 a , table3 b WHERE a.tt='asd' and b.kk='jkl' 这个可以实现插入
路过,这三张表应该有关联的。就用这条语句: INSERT INTO table1(zd1,zd2) SELECT zz,dd FROM table2 a , table3 b WHERE a.tt='asd' and b.kk='jkl'
insert table1(zd1,zd2)
select zz,dd from table2 a,table3 b
where a.关键字段=b.关键字段
insert table1(zd1,zd2)
select zz,dd
from table2 a,table3 b
where a.关键字段=b.关键字段
insert table1(zd1,zd2)
select zz,dd from(
select px=row_number()over(order by getdate()),zz from table2)a
full join (
select px=row_number()over(order by getdate()),dd from table3)b
on a.px=b.px
select zz from table2insert into table1(zd2)
select dd from table3
数据库是access2010table1(id,zd1,zd2) (id自增)
table2(tt,zz)
table3(kk,dd)zd1 = (SELECT zz FROM table2 WHERE tt='asd') 查出的结果只有1个
zd2 = (SELECT dd FROM table3 WHERE kk='jkl') 查出的结果只有1个INSERT INTO table1(zd1,zd2) ...大致过程如上
我试了几种方法都插不进数据,不知道问题出在哪里
目前还没解决,求助求助。。
update table1 set zd2 = (SELECT dd FROM table3 WHERE kk='jkl')
select zz,dd from(
select px=row_number()over(order by getdate()),zz from table2)a
full join (
select px=row_number()over(order by getdate()),dd from table3)b
on a.px=b.px--这个你确定试过了?
试过,不对INSERT INTO table1(zd1,zd2) SELECT zz,dd FROM table2 a , table3 b WHERE a.tt='asd' and b.kk='jkl'
这个可以实现插入
INSERT INTO table1(zd1,zd2) SELECT zz,dd FROM table2 a , table3 b WHERE a.tt='asd' and b.kk='jkl'
table1(id,zd1,zd2)
table2(tt,zz)
table3(kk,dd)关系如下:
table1.zd1 : table2.zz = N:1
table1.zd2 : table3.dd = N:1