sql - “嵌套”或具有多个值

Question

所以我是一个新的 SQL 用户，并且坚持是否有办法做到这一点，所以任何帮助都将不胜感激。此代码有效：

select *
from    ADMIN.ASSOCIATE_TBL A
where   (A.termination_date between '2021-05-01' and '2021-05-31'
      or A.Start_date between '2021-05-01' and '2021-05-31'
      or A.Rehire_date between '2021-05-01' and '2021-05-31')
      and employee_id='802740'
      

我想知道有没有办法将搜索字段与日期范围结合起来？查看下面的“思考过程”代码，但我知道它不起作用。

select *
from    ADMIN.ASSOCIATE_TBL A
where (a.termination_date or a.start_date or a.rehire_date) between '2021-05-01' and '2021-05-31'
and employee_id='802740'

标签： sqlnested