KPMG Interview Question

Explain SQL nested joins and different types of joins