The second query can be

select * from table1 t0

where t0.status>=0

and exists (

select...

Hi, Paul

The first query can be like this

select * from table1 t0

where t0.status=0

and not exists (

select t2.id1 from table1 t2

where...

Hey, paul, it's me, Jiangfeng. I figured out the solution already. Try below, should be working....

select t0.* from table1 t0 where

not exists (

select t2.id1 from table1 t2 where

t0.reference =...