If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Mysql syntax for update with inner join
UPDATE table1 set primaryservicelocation=('99')
FROM table2
INNER JOIN table1 ON table2.pid = table1.uid
WHERE randomvalue='363908'