如题，下面sql报错
DELETE FROM internal.ods_db.table1
where emp_no in (
select emp_no
from internal.stg_db.table2
where date_dt = '20250721'
)
报错：SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Where clause only supports compound predicate, binary predicate, is_null predicate or in predicate.
