Fix for #49: Join is now using the more sophisticated optimizations that are also used for left join - maybe this could still be improved