You mean the where exists/not exists concept? Or the select 1 usage in that correlated subquery?