added support for join delete