Hello, I'm not really sure (I'm by no means an expert) but shouldn't this be possible? UPDATE test set i_test=item.i_itemID WHERE test.i_ID=item.i_itemID; I'm getting this reply: "MySQL said: Unknown table 'item' in where clause" while of course table 'items' exists... I use mySQL service at my webhosting, so I don't have the control over the database.
Thanx Marc __________________________________________________ Yahoo! Plus For a better Internet experience http://www.yahoo.co.uk/btoffer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
