CivilSoft Interview Question

SQL statement like different between left and right join