LMSouq
database Open

How can I do three table JOINs in an UPDATE query?

RI
Ricky
1 month ago
3 views
Problem Description
I asked a question and got this reply which helped. UPDATE TABLE_A a JOIN TABLE_B b ON a.join_col = b.join_col AND a.column_a = b.column_b SET a.column_c = a.column_c + 1 Now I am looking to do this if there are three tables involved something like this. UPDATE tableC c JOIN tableB b JOIN tableA a My question is basically... is it possible to do three table joins on an `UPDATE` statement? And what is the correct syntax for it? Do I do the following? JOIN tableB, tableA JOIN tableB JOIN tableA

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base