remove unneeded join