Hey, something is wrong in your sample SELECT DISTINCT t1.ID AS ID FROM PUBLIC.AAA_STR_HIE_ACCOUNT t1 LEFT JOIN PUBLIC.AAA_STR_HIE_ACCOUNT t2 ON t2.PARENT = t1.ID AND t2.hier = t1.hier WHERE t2.PARENT IS NULL AND t1.hier = 'H4';
The resultset will be either empty or one row with null in it, but you said it's 1252 rows. if t2.PARENT = t1.ID and t2.PARENT IS NULL then t1.ID is always null. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
