UPDATE worklist_detail SET Worklist_detail.transdt = WorkList.TransDt JOIN worklist on worklist_detail.transid = worklist.transidUPDATE: Nevermind. Premature inquireulation:
UPDATE worklist_detail SET Worklist_detail.transdt = WorkList.TransDt from WorkList_Detail join worklist on worklist_detail.transid = worklist.transidThe FROM was needed.