CivilSoft interview question

SQL statement like different between left and right join