added collect inner/outer join