DISTINCT gives you all the distinct values in the column, in this case all UniqueKey 2.
Then, for each row in the first table, we check whether that UniqueKey1 is in the list of Unique Keys 2,. If so, we return a 1; otherwise a 0. If you find this helpful, please consider kudoing the posts. Check these out: