>>>>>UPDATE EmpItems >>>>> LEFT JOIN HistItems ON HistItems.eiKey = EmpItems.eiKey >>>>> WHERE HistItems.DelFlag = 0 >>>>> SET EmpItems.itOnPosted = 1, EmpItems.itBalAmt = HistItems.itBalNew + HistItems.itPostCalc >>>>>>>>>>Maybe I'm doing something wrong?
>>>>UPDATE EmpItems >>>>SET itOnPosted = 1, >>>>itBalAmt = HistItems.itBalNew + HistItems.itPostCalc >>>> >>>>FROM EmpItems >>>>INNER JOIN HistItems ON HistItems.eiKey = EmpItems.eiKey -- no need to use LEFT JOIN >>>> WHERE HistItems.DelFlag = 0 >>>>>>>
UPDATE EmpItems ; SET itOnPosted = 1, ; itBalAmt = HistItems.itBalNew + HistItems.itPostCalc; FROM HistItems where HistItems.eiKey = EmpItems.eiKey and HistItems.DelFlag = 0