use SSMS Red Gate SQL Prompt to complete a join

If you just type a space after the ON, the IntelliSense will most likely suggest the join that makes sense.