Details
-
Enhancement
-
Resolution: Unresolved
-
Major
-
None
-
None
Description
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