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

Reply via email to