General discussion

Locked

Mysql syntax for update with inner join

By cmm8907 ·
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'

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums