Bitwise interview question

Different types of joins in SQL