Nokia interview question

About Joins in Database and sql queries.