R+L Carriers interview question

Explain the different types of SQL joins