Infosys Interview Question

Write a query for inner join and outer join