This is a good explanation of the UPDATE command syntax

Re: UPDATE not working Thread #1342335 Message #1342389

>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.