UPDATE one table using JOIN in MySQL 3.23
Posted on 2005-04-05
I'm trying to update one table where a field in another table is a certain value, but I'm not sure if it's possible in v3.23 and if so, what the syntax would look like.
With an example table structure like:
t2 (b, a)
t3 (c, b, d)
I want to run something like UPDATE t1 SET f1 = 'foo' but only update that field WHERE t1.a = t2.a AND t2.b = t3.b AND t3.d = 'bar'.