added code related to reducer join