sql server 2005 查询对比两个字段数据是否一致sql 怎么写？

[Spirng_Java]

比如：
table1
字段有
id name pwd date


table2
字段有
id name pwd date

现在需要查询两个表的name 不一样的出来、以及是2016-01-01至2016-01-31 号的数据

只显示name 和 日期

[shoppo0505]

;with data as ( select id, name, pwd , date from table1 where DATE between '2016-01-01' and '2016-01-31' union select id, name, pwd , date from table2 where DATE between '2016-01-01' and '2016-01-31' ) select distinct name , DATE from data

[Spirng_Java]

引用 1 楼 shoppo0505 的回复:

;with data as ( select id, name, pwd , date from table1 where DATE between '2016-01-01' and '2016-01-31' union select id, name, pwd , date from table2 where DATE between '2016-01-01' and '2016-01-31' ) select distinct name , DATE from data

比如两个表的数据 tabl1 id name pwd date 1 李一 123 2016-01-02 2 李二 123 2016-01-03 3 李三 123 2016-01-04 3 李六 123 2015-12-04 ------------------------------------------------- tabl1 id name pwd date 1 李一 123 2016-01-02 2 李二 123 2016-01-03 3 李三 123 2016-01-04 4 李四 123 2016-01-05 ========================================= 我要查出的数据效果是 name date 李四 2016-01-05 只有上面这个是符合日期 以及两个表name对比，只要双方name 那个表没有都现实出来

[shoppo0505]

select id, name, pwd , date from table2 where DATE between '2016-01-01' and '2016-01-31' intersect select id, name, pwd , date from table1 where DATE between '2016-01-01' and '2016-01-31'