How to do update in netezza

Netezza doesn't allow like inner join in the update statement, the other way to do it

lets say you have to update tablea from tableb
here is the sql

update tablea T1 set T1.COl=T2.COL
,T1.Col1=T2.COl1
from
tableb T2 where T1.ID=T2.ID