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 overwrite ORDERNUM with ORIGORDER so the output would be:
ORDERNUM NAME EVENT ORIGORDER
3 GEE ADD <NULL>
3 MAY ADD <NULL>
other data will be the same except for ORDERNUM.
Can you please help me?
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 overwrite ORDERNUM with ORIGORDER so the output would be:
ORDERNUM NAME EVENT ORIGORDER
3 GEE ADD <NULL>
3 MAY ADD <NULL>
other data will be the same except for ORDERNUM.
Can you please help me?