What is the difference between a subquery and a join?

Related questions

1. What is still grammar?
2. What is the meaning of ex mayor?
3. WHY IS LEFT JOIN slow?
4. What is the difference between in and between in SQL?
5. What is the reality of existence?
6. Is subquery better than join?
7. What is the difference between in and exists?
8. How does all work in SQL?
9. What does exists mean in SQL?
10. What is the synonym of continuing?

Tags

1. #result
2. #subqueries
3. #scalar
4. #joins
5. #return
6. #single
7. #calculate
8. #combine
9. #common
10. #value
11. #whereas
12. #either
13. #query
14. #subquery
15. #different
16. #tables
17. #summary
18. #versus