[carmelomcc]

i amt rying to subtract what is in an temporary table/column from a regular table/column, then i want to insert that data into another column in the table.

temporary table name = xxx
temporary column name = used_size

Normal table name = chk_info

Table column = used_size

Table column to drop the data into = daily_chg


Code sample:

update chk_info set daily_chg =(xxx.used_size-chk_info.used_size);