Interesting.

Some bones to pick: https://github.com/jarulraj/sqlcheck/blob/master/docs/query/...

First, dat implicit, inner join. Second, it could be written more clearly that, in this case, the reason you want to use a join is because you are not sure that the sub-query returns at most one row.