I cant use CTE..

because the datawarehouse applicance wont support that....

all i need is single update statement with the required join condition