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 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 line 1 How can I get this done?? Ralph --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php