S&P Global interview question

What are different joins?