hi.. am such a newbie with SQL. im trying to update a table to overwrite a record .
TABLE1
ORDERNUM NAME EVENT ORIGORDER
1 GEE ADD <NULL>
2 MAY ADD <NULL>
3 CHANGE 1
3 CHANGE 2
what i want to achieve is : if EVENT is CHANGE, then...