Not sure why this is kicking back syntax errors. Not to familiar with running an update and inner join so any help would be great. Thanks
UPDATE table1 set primaryservicelocation=(’99’)
FROM table2
INNER JOIN table1 ON table2.pid = table1.uid
WHERE randomvalue=’363908′