Hi, I don't know if this is possible ( my experience with SQL is very short) but I need to update table A from table B but saving the "Old values" from certain columns into table C.
In other words I have 3 tables A,B,C. Table A is going to be updated with values from table B, but I have to keep track of these changes made to table A into table C. By tracking I mean that any row changed on A must be saved into table C ( actually not the whole row but certain columns) for example, Update tableA inner join tableB on ( id_tableA = id_tableB ) set tableA.col1 = tableB.col1, etc.., etc But when tableA.col1 is changed I would like to have the original value from id_tableA and col1 INSERTED into tableC as a new row. Is it posible to do that at the same time? I mean without creating a temporary table first then updating tableA and atfer that using the temporary table to insert the new records into tableC ? Thank you And forgive me if I couldn't make myself clear Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]