Infosys Interview Question

Intro, SQL write a query to fetch records from two diff tables using joins.