A One Salasar interview question

Tell me Something about Join Query with Examples?