表a1 A B 00001 DAS
00002 SDF
00003 ASD
00004 KJHF
00005 JKLK
.......... .........
表b1 A B ...............
00001 DGGGD .............
00001 GDGDG ...............
00001 CBCBCVB .............
00002 QEQEWQE ..........
00002 NVBNVBN .............
00002 QWDFSA ...............
00003 NVNVBNN .............
00003 VBCGFG ..........
00004 FSDF .............
00004 DASDA ...............
00005 FDSFS .............
00003 SDFFSD ..........
00003 SFFSD .............
00004 SDDSFD ...........
表c1 B C D ......
DGGGD .............
GDGDG ............... DASDA ...............
FDSFS .............
更新的结果:
表B A B
00001 DAS
00001 DAS
00001 DAS
00002 SDF
00002 SDF
00002 SDF
00003 ASD
00003 ASD
00004 KJHF
00004 KJHF.
00005 JKLK.
00003 ASD
00003 ASD
00004 KJHF
表c1 B C D ......
DAS .............
DAS ...............
KJHF ...............
JKLK ............. 更新语句怎么写数据库
00002 SDF
00003 ASD
00004 KJHF
00005 JKLK
.......... .........
表b1 A B ...............
00001 DGGGD .............
00001 GDGDG ...............
00001 CBCBCVB .............
00002 QEQEWQE ..........
00002 NVBNVBN .............
00002 QWDFSA ...............
00003 NVNVBNN .............
00003 VBCGFG ..........
00004 FSDF .............
00004 DASDA ...............
00005 FDSFS .............
00003 SDFFSD ..........
00003 SFFSD .............
00004 SDDSFD ...........
表c1 B C D ......
DGGGD .............
GDGDG ............... DASDA ...............
FDSFS .............
更新的结果:
表B A B
00001 DAS
00001 DAS
00001 DAS
00002 SDF
00002 SDF
00002 SDF
00003 ASD
00003 ASD
00004 KJHF
00004 KJHF.
00005 JKLK.
00003 ASD
00003 ASD
00004 KJHF
表c1 B C D ......
DAS .............
DAS ...............
KJHF ...............
JKLK ............. 更新语句怎么写数据库
我写的语句为
update b1 set B=(select B from a1 where a1.A=b1.A);b 表更新没什么问题update (select a.A,b.* from b1 a,c1 b where a.B=b.B) set B=(select B from a1 where a1.A=(select a.A,b.* from b1 a,c1 b where a.B=b.B).A);
c 表更新报错;应该怎么写才对