Added JOIN 0 support and fixed broken test