modified skeleton and test for delete join