[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 line 1 [/snip] Remove "IN" and see if that works UPDATE t3 set t3.mynewfield = t1.mynewfield SELECT t1.mynewfield FROM t1, t2, t3 WHERE t1.mynewfield = "1" and t2.t1id=t1.t1id and t2.t3id=t3.t3id; HTH! Jay sql mysql query --------------------------------------------------------------------- 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
