sql - Update column from inner join -

this question has answer here:

• update table using join in sql server? 9 answers

i have table of posts forum, there 1 row posting of pdf file , there row posting of image url goes pdf. took rows out of posts table , inserted them item table if pdf. have column in item table want filled row in posts table has image want

update item set i.imageurl = p.guid join posts p on i.old_id = p.parent_post p.posttype = 'image' 

i have not been able find example anywhere update uses join , has clause , have idea doing wrong?

the correct syntax in sql server looks more this:

update     set imageurl = p.guid     item join          posts p          on i.old_id = p.parent_post     p.posttype = 'image';