[snip]
UPDATE t3 set t3.mynewfield = t1.mynewfield IN SELECT t1.mynewfield FROM t1,
t2, t3 WHERE t1.mynewfield = "1" and t2.t1id=t1.t1id and t2.t3id=t3.t3id;
and I getting:
ERROR 1064: You have an error in your SQL syntax near 'SELECT t1.mynewfield
from t1, t2, t3 WHERE t1.mynewfield = "1" at lin
Hi all,
I'm trying to update a table from another table. There are three tables
involved t1, t2 and t3. Table t1 and table t3 have the data table t2 holds
the relationships, ie t2 looks like this:
t2id tinyinit
t1id tinyinit
t3id tinyinit
This is the update statment i'm trying:
UPDATE t3 s
