/*更新费用报销单上, 费用明细分录上的报销人*/
UPDATE t_er_expensedetail SET t_er_expensedetail.freimburser = (SELECT t_er_dailyreimbursebill.FApplierID FROM t_er_dailyreimbursebill WHERE t_er_expensedetail.fid = t_er_dailyreimbursebill.fid) WHERE t_er_expensedetail.freimburser = 0 AND EXISTS(SELECT 1 FROM t_er_dailyreimbursebill WHERE t_er_expensedetail.fid = t_er_dailyreimbursebill.fid);