ÇóÒ»sqlÎÊÌâµÄ½â´ð

±íAµÄÊý¾Ý½á¹¹£º
userId        date
1      2010-01-01 09:00:00
2      2010-01-02 15:30:00
...
...

±íBµÄÊý¾Ý½á¹¹£º
userId        beginDate            endDate
1        2010-01-01 08:00:00    2010-01-01 10:00:00
1        2010-01-01 14:00:00    2010-01-01 15:00:00
2        2010-01-02 09:30:00    2010-01-07 17:00:00
3        2010-01-01 08:00:00    2010-04-01 15:00:00


ÎÒÏëÒªÁгö±íAÖеÄdate²»°üº¬ÔÚ±íBµÄbegindateºÍenddateÀïµÄÊý¾Ý£¬Í¨¹ýuserid×ö¹ØÁª(±íBÖÐͬһ¸öuserid¿ÉÄÜ»áÓжàÌõ¼Ç¼)

---

SQL code:
SELECT * from A ,B
WHERE A.USERID=B.USERID
AND A.DATE NOT BETWEEN B.beginDate AND B.endDate

?

---

SQL code:
SELECT * from A
WHERE NOT EXISTS(
SELECT 1 from B WHERE A.DATE BETWEEN B.BEGINDATE AND B.ENDDATE
)

---

SQL code:
select
*
from
tb a
where
not exists (select 1 from b where