COrrected the error in the final join by adding CTI