Hexaware Technologies interview question

state inner join sql query?