In the assessement project, a colleague suggests replacing the Stack recipe with a Join recipe. Would this work?

Yes. The Join recipe can use more powerful recipe engines to achieve the same output.

The Stack recipe works here, but if there was a third input dataset, you would need to use the Join recipe.

No$.$ Stack and join are different data transformations.