changes to join function, allowing not found items on r1