Skip to content
Advertisement

How update row with inner joins

I have this select statement where I found two rows, and I want to update a specific column:

I have tried:

How do I correctly construct the update query?

SOLUTION:

Advertisement

Answer

Just put your query as a table:

Here is a demo:

DEMO

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