Infosys interview question

Write a query for inner join and outer join