What is the difference between a Subquery and a Join?

Subquery will work without having relation between tables, where as join will not work

Subquery will be used for more than one result set where Join is used for one result set

Join can be used for multiple tables, Where as Sub query cannot be used for multiple tables

None of the above

All of the above