在等待，关联表更新出错：执行失败:ORA-00933: SQL command not properly ended

执行失败:ORA-00933: SQL command not properly ended

update t1 set t1.MD$NUMBER = t2.MD$DESC
FROM SONGZ_0.GDJTYKTLJ$VF t1
inner join SONGZ_0.PDMTEST$SF t2 on t1.MD$NUMBER=t2.MD$NUMBER
查询是没有问题的
SELECT t1.MD$NUMBER,t2.MD$DESC
FROM SONGZ_0.GDJTYKTLJ$VF t1
inner join SONGZ_0.PDMTEST$SF t2 on t1.MD$NUMBER=t2.MD$NUMBER


不知道哪里出错了，相同的语句在SQL SERVER里正常，
再线等待，希望哪位大侠帮忙指点一下，谢谢！

自己找到办法了
update SONGZ_0.GDJTYKTLJ$VF t1 set t1.MD$NUMBER = (select t2.MD$DESC FROM SONGZ_0.PDMTEST$SF t2 
where t2.MD$NUMBER=t1.MD$NUMBER)
where exists (select 1 FROM SONGZ_0.PDMTEST$SF t2 
where t2.MD$NUMBER=t1.MD$NUMBER)
看来orcal语法还是有特殊的地方

这些差别有时候会让人很迷惑.