[ https://issues.apache.org/jira/browse/DERBY-2012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhilash T.G reassigned DERBY-2012: ----------------------------------- Assignee: Abhilash T.G > The Syntax of the UPDATE and DELETE statements is not correct in the > reference manual > ------------------------------------------------------------------------------------- > > Key: DERBY-2012 > URL: https://issues.apache.org/jira/browse/DERBY-2012 > Project: Derby > Issue Type: Improvement > Components: Documentation > Reporter: Christian d'Heureuse > Assignee: Abhilash T.G > Priority: Minor > > The syntax description of the UPDATE and DELETE statements in the reference > manual does not imply that an alias name may be specified for the table name. > The statements are currently documented as: > UPDATE table-Name > SET ... > DELETE FROM table-Name > [ WHERE ... ] > This should be changed to: > UPDATE table-Name [ [ AS ] correlation-Name ] > SET ... > DELETE FROM table-Name [ [ AS ] correlation-Name ] > [ WHERE ... ] > (Table alias names for UPDATE and DELETE are important for the WHERE clauses, > e.g. when the same table is used a second time within a subquery in the WHERE > condition, e.g.: > UPDATE table1 a > SET ... > WHERE EXISTS ( > SELECT * FROM table1 b WHERE a.field1 = b.field2 ) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.