[teiid-issues] [JBoss JIRA] (TEIID-4591) support UPDATE SQL JOIN / FROM

[Omar Khan (JIRA)]

Omar Khan created TEIID-4591:
--------------------------------

             Summary: support UPDATE SQL JOIN / FROM
                 Key: TEIID-4591
                 URL: https://issues.jboss.org/browse/TEIID-4591
             Project: Teiid
          Issue Type: Enhancement
            Reporter: Omar Khan
            Assignee: Steven Hawkins


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 single rows. 

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





--
This message was sent by Atlassian JIRA
(v7.2.3#72005)