Conditional (inequality / non-equi) joins are joins based on comparison operators other than the equal sign. Where relevant, conditional joins can provide significant performance gains and reduced memory requirements.