removal of joins