New join trans coded
now testing and debugging