sqlÓï¾ä¡£¡£ - MS-SQL Server / »ù´¡Àà

ÏÖÓÐA B Á½±í 

A±í¼Ç¼Èç
name no times date
ÕÅÈý 002 1 2008-12-01
ÕÅÈý 002 2 2008-12-22
ÕÅÈý 002 3 2009-12-01
ÀîËÄ 010 1 2005-01-01
ÍõÎå 022 2 2004-01-23
B±í¼Ç¼Èç
name no times date
ÕÅÈý 002 1 2008-12-01
ÕÅÈý 002 2 2008-12-22
ÕÅÈý 002 3 2009-12-01
ÕÅÈý 002 4 2010-12-01
ÕÅÈý 002 5 2010-12-22
ÕÅÈý 002 5 2010-12-29 £¨´ÎÊýÒ»Ñù£¬ÈÕÆÚ²»Ò»Ñù£©
ÀîËÄ 010 2 2005-12-23
ÍõÎå 022 4 2007-01-23
ÍõÎå 022 5 2007-01-25

ÎÒÒª²é³öB±íÀïA±íûÓеļǼ¡£¡£¡£Õâ¸öSQLÔõôд°¡¡£¡£

---

select * from b where not exists(
select 1 from a where a.name=b.name and a.no=b.no and a.times=b.times and a.date=b.date)

---

SELECT * from B EXCEPT SELECT * from A;

---

SQL code:
select * from tb
except
select * from ta

---

SQL code:
select *
from b
where not exists(select 1 from a where name=b.name and no=a.no and times=a.times and [date]=t.[date])

---

ÒýÓÃ

SQL code
-----------------------------------