The advantage of a join includes that it executes faster.
The retrieval time of the query using joins almost always will be faster than
that of a subquery. By using joins, you can maximize the calculation burden on
the database i.e., instead of multiple queries using one join query