As a serial bodger I might consider using a different trap, maybe a P trap, and run the waste straight through the centre of that joist. Then If the hole size was larger than allowed for joist depth or hole position, I would tie the joist to the wall to lend support. Just ideas...