Why why why

Why can't i remember this? I use it all the time, it's simple and i have no goddam recall. Placing here for reference.

Update from:

update tblx
SET tblx.YEGoal = jj.yeg
FROM tblx ke
INNER JOIN jjttmp jj ON (ke.id = jj.storeid and ke.type = 's')