Philips interview question

inner and outer join