比对两个表内容,SQL语法求助 update a set a3=b.a3 ,a4=b.a4 From testa ajoin testb b on a.A1=b.A1 and a.A2=b.A2 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 update a set a.a3=b.a3,a.a4=b.a4 From testa a,testb bwhere a.a1=b.a1 and a.a2=b.a2 --测试create table testA (a1 char(2),a2 char(2),a3 char(2),a4 char(2))create table testB (a1 char(2),a2 char(2),a3 char(2),a4 char(2))insert into testA values(11,12,0,0)insert into testA values(11,13,0,0)insert into testA values(11,10,0,0)insert into testB values(11,12,1,2)insert into testB values(11,11,1,2)insert into testB values(11,13,1,3)update TESTA set a3=b.a3,a4=b.a4 From testa a,testb b where a.a1=b.a1 and a.a2=b.a2--结果select * from testA11 12 1 2 11 13 1 3 11 10 0 0 QT SQL SERVER 连接问题 请教sql server 2000中线程和纤程的区别 2个表的问题 如何知道服务器端T1表的数据在上一次访问过后又发生了变化?SQLSERVER的语句怎么写? 熟悉动态sql的高手,帮忙想想招 如何从数据库直接生成 insert 语句? 这个怎么会错???? 不使用子查询实现表关联 请教----如何将列变成行??? sql解析器解析带变量的sql语句 可以批量设置用户对表的权限吗? win2003安装sql server2000,没有成功
where a.a1=b.a1 and a.a2=b.a2
create table testA (a1 char(2),a2 char(2),a3 char(2),a4 char(2))
create table testB (a1 char(2),a2 char(2),a3 char(2),a4 char(2))
insert into testA values(11,12,0,0)
insert into testA values(11,13,0,0)
insert into testA values(11,10,0,0)
insert into testB values(11,12,1,2)
insert into testB values(11,11,1,2)
insert into testB values(11,13,1,3)update TESTA set a3=b.a3,a4=b.a4 From testa a,testb b where a.a1=b.a1 and a.a2=b.a2--结果
select * from testA11 12 1 2
11 13 1 3
11 10 0 0