added support for delete join