UPDATE FROM other table

update story
set DigitalIssueLink = 

(select Yudulink from MagYuduUrls y 
where y.IssueCode = story.IssueCode 
and y.MagazineID = story.MagazineID)

update questions  set hint = a.hint from answers a inner join questions q on a.questionId = q.questionId where a.IsCorrect = 1

Generate an update based on an original query

Original Query

select oi.OrderItemId, Item, Month, Year, oi.IssueId, instructions, im.Deadline from orderitems oi 
inner join issues i on oi.issueid = i.issueid
inner join OrderItemTypes oit on oi.OrderItemTypeId = oit.OrderItemTypeId
inner join issuemilestones im on im.issueid = i.issueid
inner join milestones m on im.MilestoneId = m.MileStoneId
where 
m.IsCopyDeadline = 1 and
oit.OrderItemCategoryId = 1 and
oi.instructions is not null and 
oi.year >= 2026 and 
oi.Deleted  = 0
order by oi.issueid

UPDATE From statement

update oi
set instructions = 'PDF by ' + format(im.Deadline, 'ddd MMM dd, yyyy')
from orderitems oi
inner join issues i on oi.issueid = i.issueid
inner join OrderItemTypes oit on oi.OrderItemTypeId = oit.OrderItemTypeId
inner join issuemilestones im on im.issueid = i.issueid
inner join milestones m on im.MilestoneId = m.MileStoneId
where 
m.IsCopyDeadline = 1 and
oit.OrderItemCategoryId = 1 and
oi.instructions is null and 
oi.year >= 2026 and 
oi.Deleted = 0