ADB Safegate interview question

how does an SQL join work