An excellent question.

I'm guessing that the join syntax is preferred as you can use it to easily express the intention of left and right joins too, which I don't know...

This is fab stuff, both the code, and all the reports.

Presumably there is negligible impact on performance from the trigger based solution?