adding and removing only specified file in a table

[Aleathiel]

Hi all,

Here is my problem:

I have a table with 6 field that are: SO_NO, SO_STATUS, CUST_CODE, REQUEST SHIP DATE, SHIPPING INSTR, QTY ORDERED

I want to delete the entire row only for the SO_NO that are finished (this is taken with the SO_STATUS while "4" is not finished, "9" is finished) and only add the one that aren't already in the table, is there a way to do that?

Right now I only have a query that delete everything and add all the list of what is in status 4.

Any help would be greatly appreciated, thanks.

Myrdinn

 

[mp9]

To delete just those that are finished, ie. those that have SO_STATUS of 9:

DELETE * FROM YourTableNameHere WHERE SO_STATUS=9;