Usage of Correlated Sub Query should be avoided in SQL as normally it takes more time to execute.
JOIN is always faster.
By looking into COST in the first line of the output, you can judge which one is better. Lowest cost is better one.