sqlÓÅ»¯

ÎÒµÄsqlÓï¾äÈçÏÂ
select *¡¡from £ô£±¡¡where to_char(kf_date,'yyyy-mm') = '2009-09' AND kf_caller NOT IN
(select kf_caller from £ô£±where to_char(kf_date,'yyyy-mm') = '2009-10' )

Ò²¾ÍÊDZ¾±í²éѯ ²éÕÒ9ÔÂÊý¾ÝûÔÚ10ÔµÄ

---

SQL code:
select *¡¡from £ô£±¡¡where to_char(kf_date,'yyyy-mm') = '2009-09' AND kf_caller NOT exists
(select kf_caller from £ô£±where to_char(kf_date,'yyyy-mm') = '2009-10' )

---

...  1lou  ÎÞÓï

---

in ºÍ existsÔÚЧÂÊÊÇÓвîÒì!Äã¿ÉÒÔÏÈÊÔÊÔÔÚ˵!

---

ÒýÓÃ

in ºÍ existsÔÚЧÂÊÊÇÓвîÒì!Äã¿ÉÒÔÏÈÊÔÊÔÔÚ˵!

UP

---

ÕæµÄÂ𠣿ÄѵÀÊÇ8IµÄÔ­Òò±¨´í £¿ »¹ÓÐÄãÓõÄÍâ¹ØÁª ÎÒÔç¾ÍÊÔ¹ýÁË ²»ÐР ±¨´íµÄ£¡

---

¹ØÁª ºÃÏñÊÇÎÒ¶ªÁ˸öÀ¨ºÅ£¡ º¹ÑÕ