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

by

The answer is yes, you can.

Try it like this:

UPDATE TABLE_A a
    JOIN TABLE_B b ON a.join_col = b.join_col AND a.column_a = b.column_b
    JOIN TABLE_C c ON [condition]
SET a.column_c = a.column_c + 1

For a general update join:

UPDATE TABLEA a
JOIN TABLEB b ON a.join_colA = b.join_colB
SET a.columnToUpdate = [something]

More Related Contents:

  1. How can I select data from different tables?
  2. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  3. 1052: Column ‘id’ in field list is ambiguous
  4. MySQL: Quick breakdown of the types of joins [duplicate]
  5. Join between tables in two different databases?
  6. MySQL update table based on another tables value
  7. Required to join 2 tables with their FKs in a 3rd table
  8. MySQL join with where clause
  9. JOIN queries vs multiple queries
  10. Why does MySQL report a syntax error on FULL OUTER JOIN?
  11. conditional join in mysql
  12. MYSQL Select MAX Date inside a join statement
  13. CROSS/OUTER APPLY in MySQL
  14. Mixing ANSI 1992 JOINs and COMMAs in a query
  15. a count for each join – optimisation
  16. Cumulative sum over a set of rows in mysql
  17. MySql Count cannot show 0 values
  18. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  19. MySQL JOIN the most recent row only?
  20. MySQL update a joined table
  21. MySQL join query using like?
  22. MySQL JOIN with LIMIT 1 on joined table
  23. Difference between these two joining table approaches?
  24. Laravel join with 3 Tables
  25. MySQL Insert & Joins
  26. How to join two tables using a comma-separated-list in the join field
  27. When to use a left outer join?
  28. In what order are MySQL JOINs evaluated?
  29. MySQL cartesian product between two SELECT statements
  30. MySQL Multiple Joins in one query?

Leave a Comment