ADB Safegate Interview Question

how does an SQL join work