Re: SQL Update Table Based on Join and Multiple Where Clauses

[Phillip Ward]

MySQL's "update from multiple tables" syntax goes like this:

UPDATE table1 t1
INNER JOIN table2 t2 ON t1.? = t2.? ... 
SET table1.value = ... 
WHERE ...

So, in your case, I think it should be something like:

UPDATE tbl_appointment a
LEFT JOIN join tbl_client c 
       ON c.id = a.client_id
SET a.active_app = 0
WHERE c.mfl_code = '10808'
  AND a.app_status = 'LTFU'
  AND a.active_app = 1 ;

Regards, Phill W.