select * from oa_send_msg t where
not exists (select a.business_id from oa_reading_info a where a.opr_id = '2' and a.business_id = t.id)
and t.tmp_id is not null and t.main_send = '[99]广建科技'
exists
最新推荐文章于 2024-04-24 08:00:00 发布
select * from oa_send_msg t where
not exists (select a.business_id from oa_reading_info a where a.opr_id = '2' and a.business_id = t.id)
and t.tmp_id is not null and t.main_send = '[99]广建科技'