Inner join with update sql statement giving error : I am making a sql statement which is giving an error for innerjoin with update 

Following is the query: 

UPDATE trackedentitydatavalue tedv INNER JOIN dataelement de ON tedv.dataelementid=de.dataelementid 
SET tedv.value=tedv.value+'_123' where de.valuetype='TEXT' and  de.optionsetid is NOT NULL AND  RIGHT(tedv.value,3)!='123' 

giving following error: 
ERROR:  syntax error at or near "INNER"
LINE 1: UPDATE trackedentitydatavalue tedv INNER JOIN dataelement de
