Re: query question: updating between 2 tables

2006-09-19 Thread Philippe Poelvoorde
2006/9/19, Peter Van Dijck <[EMAIL PROTECTED]>: Hi all, trying to figure out if there is a query I can use for this, or if I have to write a php script to loop tru each row... table1: entryid int(11) itemid int(11) table2: object_id int(11) The situation is: table2.objectid is populated w

query question: updating between 2 tables

2006-09-19 Thread Peter Van Dijck
Hi all, trying to figure out if there is a query I can use for this, or if I have to write a php script to loop tru each row... table1: entryid int(11) itemid int(11) table2: object_id int(11) The situation is: table2.objectid is populated with the values of table1.itemid, but they have to