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

[Omar Khan (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Omar Khan updated TEIID-4591:
-----------------------------
    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



  was:
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





> 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 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



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