accessÔõô²éѯÕâ¸ö - MS-SQL Server / »ù´¡Àà

and id not in (select distinct client from tb_talk where DATEDIFF('d', #"&date&"#, adddate)<=45)

Õâ¸öÊÇ´Ótb_clientÖÐÕÒ³ö³¬¹ý45ÌìûÓÐÔÚtb_talk ÓмǼµÄÊý¾Ý
½á¹ûòËÆÊǶԵÄ
µ«Ð§ÂÊÌ«µÍÁË

ÎÒÏëÕâÑùÓ¦¸Ã¿ìÒ»µã
and (select 1 from em_talk where client = tb_client.id DATEDIFF('d', #"&date&"#, adddate)<=45) ²»´æÔÚ
µ«²»ÖªÓ¦¸ÃÔõôд

---

ACCESSÖв»ÖªµÀÓÐûEXISTS

---

SQL code:
select * from tb t where ... and not exists (select * from tb_talk where DATEDIFF('d', #"&date&"#, adddate)<=45 and t.id=client)

---

SQL code:
and id not in (select client from tb_talk where DATEDIFF('d', #"&date&"#, adddate)<=45)--È¥µôdistinct

---

and not exists (select 1 from tb_talk where client = em_client.id and DATEDIFF('d', #"&date&"#, adddate)<=45)

ÕâÑù¿ÉÒÔÁË