select * from
a,b
where
a.pk=b.pk
and a.日期4 between b.日期5 and b.日期3
and b.日期2 between b.日期3 and b.日期1
a,b
where
a.pk=b.pk
and a.日期4 between b.日期5 and b.日期3
and b.日期2 between b.日期3 and b.日期1
from a,b
where a.pk = b.pk
and b.date1>=b.date2
and b.date2>=b.date3
and b.date3>=a.date4
and a.date4>=b.date5;
from a,b
where a.pk = b.pk
and not (b.date1>=b.date2
and b.date2>=b.date3
and b.date3>=a.date4
and a.date4>=b.date5);
加个not可能会慢一些