0

I'm getting the error the 'The SQL command is not properly ended.' when trying to run this query. Can someone please help me to recognize what the issue of this is.

UPDATE PM_ACTION_CALENDAR_PLAN_TAB 
   SET t1.GEN_DATE = t2.GEN_DATE 
  FROM PM_ACTION_CALENDAR_PLAN_TAB t1 
       INNER JOIN  GEN_DATEPREPARE2 t2 
         ON t1.PM_NO = t2.PM_NO AND 
            t1.SEQ_NO=t2.SEQ_NO AND 
            t1.PM_REVISION=t2.PM_REVISION;
user3789200
  • 1,166
  • 2
  • 25
  • 45
  • 2
    Oracle doesn't support `update .. from .. join` sysntax. User [merge](https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9016.htm#SQLRF01606) instead. – Nick Krasnov May 26 '17 at 06:36
  • Hi How can I do this in oracle? – user3789200 May 26 '17 at 06:37
  • 1
    UPDATE t1 SET t1.GEN_DATE = t2.GEN_DATE FROM PM_ACTION_CALENDAR_PLAN_TAB t1 INNER JOIN GEN_DATEPREPARE2 t2 ON t1.PM_NO = t2.PM_NO AND t1.SEQ_NO=t2.SEQ_NO AND t1.PM_REVISION=t2.PM_REVISION; – Singh Kailash May 26 '17 at 06:52

1 Answers1

1

try this

  UPDATE PM_ACTION_CALENDAR_PLAN_TAB  t1
       SET t1.GEN_DATE = (select t2.GEN_DATE 
                            from GEN_DATEPREPARE2 t2 
                           where t2.PM_NO = t1.PM_NO 
                             AND t2.SEQ_NO = t1.SEQ_NO 
                             AND t2.PM_REVISION = t1.PM_REVISION)
Vecchiasignora
  • 1,275
  • 7
  • 6