MySQL – UPDATE query referring to another table

QuestionsMySQL – UPDATE query referring to another table
sethbeckerman5 Staff asked 4 years ago

I need to update some records in one table by clause from another.
table_A – status to change

ID
DID
status
value

1
29
OK
X-9

2
29
OK
X-8

3
29
OK
X-6

table_B – clause

v_1
v_2

X-9
2022-07-13

X-8
2022-06-30

X-6
2022-06-30

I tried by this query but doesnt work…

I will be grateful for your help


View on Stack Overflow