Hi Ddee,

You can achieve the desired result using the following SQL query:

sql

SELECT ID, flag, name

FROM your_table t

WHERE (flag = 0 AND NOT EXISTS (SELECT 1 FROM your_table WHERE ID =...