【ASP - Insert n Update multi table】

inbox table - whenever the processed data, status is to become R.
goodslist table - the data is fix.
savedata table - saving new information.

For example:

how to insert all data to "savedata table"

 

what is the purpose of the third table? It is simply repeating data that already exists in another table, and isn't necessary.

 

thank you... problem solve ...