没分了!但是还请大家帮我一下! update set a.value2=b.value2,..,...,.. from a,b where a.id=b.id 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create table tb(date_col char(10),name_col varchar(10))insert into tb(date_col,name_col) values('2006-10-10', 'AAA')insert into tb(date_col,name_col) values('2006-10-11', 'AAA')insert into tb(date_col,name_col) values('2006-10-12', 'AAA')insert into tb(date_col,name_col) values('2006-10-11', 'BBB')insert into tb(date_col,name_col) values('2006-10-19', 'CCC')create table tb1(date_col char(10),name_col varchar(10))insert into tb1(date_col,name_col) values('2006-10-10', 'AAA')insert into tb1(date_col,name_col) values('2006-10-11', 'AAA')insert into tb1(date_col,name_col) values('2006-10-12', 'AAB')insert into tb1(date_col,name_col) values('2006-10-11', 'BBB')insert into tb1(date_col,name_col) values('2006-10-19', 'CCC')--语句select date_col,name_colfrom tbwhere not exists(select * from tb1 where tb.date_col = tb1.date_col and tb.name_col = tb1.name_col)--结果2006-10-12 AAA 求SQL分类汇总,统计每月、每客户订单金额语句 存储过程执行传入像这样的参数时{30278028-852D-41D8-98A3-12658F6B3DB3}出错 如何将存储过程返回记录集保存到DataTable里?存储过程又将如何写呢 请教: 有一sql语句执行速度太慢,如何提高查询速度? 寻数据的导入导出的解决方案 求救!更换服务器后,进程阻塞问题! 请教各位大狭 关于REPORTING SERVICES问题 怎么用SQL语句往一个表中添加一列? 在线等,100分散尽求一行注释(15字以内) 跪求超难SQL 急请教一个SQL语句
(
date_col char(10),
name_col varchar(10)
)insert into tb(date_col,name_col) values('2006-10-10', 'AAA')
insert into tb(date_col,name_col) values('2006-10-11', 'AAA')
insert into tb(date_col,name_col) values('2006-10-12', 'AAA')
insert into tb(date_col,name_col) values('2006-10-11', 'BBB')
insert into tb(date_col,name_col) values('2006-10-19', 'CCC')create table tb1
(
date_col char(10),
name_col varchar(10)
)insert into tb1(date_col,name_col) values('2006-10-10', 'AAA')
insert into tb1(date_col,name_col) values('2006-10-11', 'AAA')
insert into tb1(date_col,name_col) values('2006-10-12', 'AAB')
insert into tb1(date_col,name_col) values('2006-10-11', 'BBB')
insert into tb1(date_col,name_col) values('2006-10-19', 'CCC')
--语句
select date_col,name_col
from tb
where not exists(select * from tb1 where tb.date_col = tb1.date_col and tb.name_col = tb1.name_col)
--结果
2006-10-12 AAA