[RESOLVED] Moving db table column field values to another db table - help

[ppowell]

This is what I tried:

update student_db.student set activities = (select i.activities from client.student c, student_db.student s where c.unique_key = s.unique_key);
ERROR 1093 (HY000): You can't specify target table 'student' for update in FROM clause
mysql>      

I just need to move all of the contents in client.student.activities to student_db.student.activities, how do I do that?

Thanx
Phil

[ppowell]

Who'd a thunk you could do multi-table updates??

UPDATE table1, table2 SET table1.col = table2.col WHERE table1.col2 = table2.col2

Phil