support UPDATE SQL JOIN / FROM

Teiid currently supports basic SET = value WHERE = value syntax.

Having the ability to join for an UPDATE would allow to be pulled from various sources and not value updates at a time.

The link below contains examples of various syntaxes of an UPDATE with a JOIN could be accomplished.

http://stackoverflow.com/questions/1293330/how-can-i-do-an-update-statement-with-join-in-sql

This enhancement request was the result of the discussion here:
https://developer.jboss.org/thread/273066