Thanks, I haven't thought about that, then it's better to write INNER JOIN to make that more clear.
>- SQL Server is picky about order of the clauses in a statement. They should be in the order as shown in BOL
>- 'WHERE HistItems.DelFlag = 0' effectively turns your LEFT JOIN into INNER JOIN.
>
>>is something like this possible? I get an error, but I thought it should have worked:
>>
>>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?
Christian Isberner
Software Consultant