KPMG interview question

Explain SQL nested joins and different types of joins