在2005.net中如何将从2005数据库多表联合查询出的数据写回到另一表中

本数据库有5张表.有(项目表) item_table (salaryid,salaryitem,salarynumber,itemid) ;                                                  (人员考核表)kaohe_table(kaoheid,id,salaryid,nowtime);                                                                                                                                            (人员表)    name_table(id,name);                                                                                                                                              (考核类型表) type_table(itemid,items,itemnumber);                                                                                                                   (联全查询出的结果要写回的表)display_table(displayid,name,safty,service,clear,quality,method,countmoney,nowtime)

查询语名:        string sql = "SELECT b.name, SUM(CASE c.itemid WHEN '1' THEN c.salarynumber ELSE 0 END) AS a,                                                                                                                                                                                        SUM(CASE c.itemid WHEN '2' THEN c.salarynumber ELSE 0 END) AS b,                                                                  SUM(CASE c.itemid WHEN '3' THEN c.salarynumber ELSE 0 END) AS c,                                                                   SUM(CASE c.itemid WHEN '4' THEN c.salarynumber ELSE 0 END) AS d,                                                              SUM(CASE c.itemid WHEN '5' THEN c.salarynumber ELSE 0 END) AS e,                               a.nowtime                                                                                                                                                                            FROM kaohe_table AS a INNER JOIN name_table AS b ON a.id = b.id INNER JOIN Item_table AS c ON a.salaryid = c.salaryid INNER JOIN Type_table AS d ON c.itemid = d.itemid                                                          WHERE (a.nowtime = '"+要查询时间+"')                                                                                                                    GROUP BY b.name, a.nowtime";
                 以上联系合查询出的a,b,c,d,e,nowtime各个列的数据写回到display_table表相应的字段中去.                                 a---对应字段-------safty            b----对应字段------service                                                                   c----对应字段-------clear                                        d-----对应字段----quality  

查询出的结果,我不知道如何写回到display_table表中去,请高手帮忙.谢谢.