Support join statements in updates. Closes #1228.