sql 语句 - .NET技术 / ASP.NET

两张表

tb1

id riqi
aa 2010.01.01
aa 2010.02.02
bb 2010.01.01
bb 2010.02.02
cc 2010.01.01

tb2

id riqi
aa 2010.01.01 
bb 2010.01.01
bb 2010.02.02

想要得到的结果为 
id riqi  
aa 2010.02.02
cc 2010.01.01

---

没有唯一键

---

select * from tb1 where (id+cast(riqi as varchar)) not exists (select (rd+ cast(riqi as varchar)) ss from tb2)

---

select * from tb1 where (id+cast(riqi as varchar)) not in (select (rd+ cast(riqi as varchar)) ss from tb2)

---

select * from tb1 where (id+cast(riqi as varchar)) not exists (select (rd+ cast(riqi as varchar)) ss from tb2)===>
select * from tb1 where (id+cast(riqi as varchar)) not in (select (rd+ cast(riqi as varchar)) ss from tb2)

---

2楼正解，not exists 换成 not in 也一样

---

这位老哥回帖好快。。。。。。

---

SQL code:

select * from tb1 t1 where not exists(select 1 from tb2 where id=t1.id and riqi=t1.riqi)

---

引用

这位老哥回帖好快。。。。。。

这年头 手慢了不行

---

想要的是 select max(riqi),id from tb1 group by id 这个不在tb2中的

---

网速快，机器好，能力强。
斗不过你们啊。。。。55555

---

都好快
{{----}