deleted join