General discussion


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 = 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