Below is an example of an Update that has an Inner Join
UPDATE
Taskevent
SET
RebateProcessed = 1
FROM
TaskEvent
INNER JOIN
TaskEventAsset
ON TaskEvent.Id = TaskEventAsset.Id
WHERE
PatientId = @PatientID
AND
JobDate < @PriorTo
AND
ConcentratorId = @ConcentratorId
