Informatica interview question

SQL related questions, like join.