Larsen & Toubro Interview Question

How joins works in SQL