Exness interview question

How join algorithms works in database?