one question. I was looking about the join and best practices. But I have not found any info.

Why is not a best practice the use of join? do you have a link or a little explanation about that, pls :)