It's ANSI-SQL...

UPDATE Alias1 SET Alias1.Field1=Alias2.Field1 FROM Table1 Alias1 INNER JOIN Table2 Alias2 ON Alias2.Field2=Alias1.Field2

MartinaJ

>What's wrong with this UPDATE statement?
>
>

>UPDATE worklist_detail SET Worklist_detail.transdt = WorkList.TransDt JOIN worklist on worklist_detail.transid = worklist.transid
>

>
>UPDATE: Nevermind. Premature inquireulation:
>
>

>UPDATE worklist_detail SET Worklist_detail.transdt = WorkList.TransDt from WorkList_Detail join worklist on worklist_detail.transid = worklist.transid
>

>
>The FROM was needed.