Hi all! I'd like to replace the values of nIndex field in NewOrder table with the values of the same field in the table InvMast...
In MySQL 4 it is like this: "UPDATE neworder, invmast SET NewOrder.nIndex = InvMast.nIndex WHERE neworder.sItemNo = invmast.sItemNo" The problem is this does not work in version 3.23 and need to re-write the Select Statement... Any suggestions? Thanks, Carlos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
