What are the different types of JOIN in SQL and when would you use each?

Review the concept and prepare a concise verbal explanation with a real project example.