[dfe]

Your own article points out that exists handles the first case. Exists is not actually implemented as a subquery, it is merely syntactically a subquery.

[chuliomartinez]

Sure exists make sense if you dont need columns from the child table. Exists is also far from basic sql.