Discussion Locked
Mysql syntax for update with inner join
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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'