Bank of America interview question

What is an inner, left and right join in SQL?