join: discard modified group fields and add left join