Philips Interview Question

inner and outer join