Larsen & Toubro interview question

How joins works in SQL