MySQL – UPDATE query referring to another table

I need to update some records in one table by clause from another.

table_A – status to change

table_B – clause

I tried by this query but doesnt work…

UPDATE
    table_A
SET
    table_A.status = "NOK"
FROM
    table_A AS table_A
    INNER JOIN table_B AS table_B
        ON table_A.value = table_B.v_1
WHERE
        table_A.DID = 29 
    AND table_A.status = "OK" 
    AND table_B.v_2 < NOW()

I will be grateful for your help

>Solution :

This is basic syntax errors when using UPDATE query
Your query should be something like:

UPDATE
    table_A AS table_A
    INNER JOIN table_B AS table_B
        ON table_A.value = table_B.v_1
SET
    table_A.status = "NOK"
WHERE
        table_A.DID = 29 
    AND table_A.status = "OK" 
    AND table_B.v_2 < NOW()

Give it a try