sql ±í²éѯ

table1¡¾±í1¡¿

t1_lsbh t1_flh
-------------------------------
xsfa123 001  
xsfa123 002  
sssssss 001  


table2¡¾±í2¡¿

t2_lsbh t1_flh
-------------------------------
xsfa123 001  


Ï£Íû½á¹û:

t1_lsbh t1_flh
------------------------------- 
xsfa123 002  
sssssss 001  

Ò²¾ÍÊDZí2´æÔÚ±í1µÄÊý¾Ý£¬ÔòÏàͬµÄ±í1²»ÏÔʾ³öÀ´
ÇóSQLÓï¾ä

---

SQL code:
select * from table1
except
select * from table2

---

ÎÒµÄÊÇsql2000

---

SELECT *
from table1 t1
WHERE NOT EXIST (SELECT * from table2 t2 WHERE t1.t1_lsbh=t2.t1_lsbh AND t1.t1_flh=t2.t1_flh)

---

SQL code:
select a.*
from t1 a left join t2 b
on a.t1_lsbh=b.t1_lsbh
and not exists(select 1 from t1 where t1_lsbh=a.t1_lsbh and t1_flh>a.t1_flh)

---

SQL code:
SELECT * from ±í1 a where not exists(select 1 from ±í2 where checksum(t2_lsbh,t1_flh)=CHECKSUM(a.t1_lsbh,a.t1_flh))

---

¼ÓÍâ2¸ö±íµÄ×Ö¶ÎÃû³ÆÆäʵÊDz»Ò