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.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums