Skip to content
Advertisement

How do i perform a conditional update in SQL with data from multiple tables?

Trying to run an update on a column and i’m getting a syntax error on the FROM line connecting the tables

Advertisement

Answer

The WHERE clause belongs at the end of the update join statement:

See SQL update query using joins for a good canonical answer to your question.

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement