IGATE Interview Question

I was asked to write a outer join query.