Ò»SQLÓï¾ä¡£ - MS-SQL Server / Ó¦ÓÃʵÀý

½²Êý¾Ý´Ótk_inalert00 ²å½ø tk_in00
SQL code:

select * from tk_in00
where exists (select shop_id,alt_id from tk_inalert00 where tk_in00.shop_id=tk_inalert00.shop_id and tk_in00.in_id=tk_inalert00.alt_id)



ÉÏÃæÒѾ­²éѯ³öÁËtk_inalert00Óëtk_in00 ÖÐÒѾ­²åÈëµÄÊý¾Ý

Ôõô²éѯ³ö δ²åÈëµÄÊý¾Ý¼Ç¼

---

select * from tk_in00
  where not exists (select shop_id,alt_id from tk_inalert00 where tk_in00.shop_id=tk_inalert00.shop_id and tk_in00.in_id=tk_inalert00.alt_id)

---

exists

¸Ä³Énot exists²»¾Í¿ÉÒÔÁËô

---

SQL code:
select * from tk_inalert00
where not exists (select shop_id,alt_id from tk_in00
where tk_in00.shop_id=tk_inalert00.shop_id and tk_in00.in_id=tk_inalert00.alt_id)

---

ÒýÓÃ

SQL code
select * from tk_inalert00
where not exists (select shop_id,alt_id from tk_in00
where tk_in00.shop_id=tk_inalert00.shop_id and tk_in00.in_id=tk_inalert00.alt_id)

лл