select *
from (
select 'CC23040108550343' as cc_task_code -- 数据作为已张表
) a
where a.cc_task_code not in(select DISTINCT( `cc_task_code`) from `t_consistency_cp` where `cc_task_code` is not null)
mysql独立数据作为一张表
于 2024-02-20 10:01:14 首次发布
select *
from (
select 'CC23040108550343' as cc_task_code -- 数据作为已张表
) a
where a.cc_task_code not in(select DISTINCT( `cc_task_code`) from `t_consistency_cp` where `cc_task_code` is not null)