SQL

What is performance wise better join or a subquery ?

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