remove unnecessary join