select p.* from agmessageprocessor p
where exists(
select 1 from agprocessortoevent pe where pe.agmessageprocessorid = p.id
and exists (
select 1 from agaccountevent ae where ae.id = pe.agaccounteventid
and exists (
select 1 from agaccount a
where (a.name ='Wl_CancelAccount1' or a.name='Wl_CancelAccount2') and a.createdloginname = 'jack|JACK'
and a.id = ae.agaccountid
)
)
);
sql exists
最新推荐文章于 2024-07-16 22:01:53 发布