>>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 >I was so used to flip that around in VFP!