Fix join docblocks.

Corrects syntax errors and changes the examples to match the
description and the actually generated SQL.
Further join() docblock improvements

Add example for array usage, simplify docblocks, fix yoda
conditions and typos
Merge pull request #5450 from ndm2/3.0-fix-join-docblocks

3.0 - Fix join docblocks