Is their a way of using insert into newtablename select * from oldtablename where ID=xxx
But with an aditional column in newtablename V!nay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]