update value from subquery

[ktucci]

how could i update a field with a value from a subquery...or is their another method of doing this
any help will be greatly appreciated
thanks in advance

update orders
set commissionable = 'this needs to be a value of a field from the subquery below'
where dbo.orders.id in (select id from orders where earned = '1' and commissionable is null)

 

[Cagliostro]

No problems:
update orders
set commissionable = (select xxx from yyy)
where dbo.orders.id in (select id from orders where earned = '1' and commissionable is null)
the basic condition is wat the subquery must return only one single value(it can be max, min, avg, top 1,...) John Fill

ivfmd@mail.md

 

[majorbroncosfan]

Is there any way to do this with multiple updates? For example, I have two tables and need to do a multiple-row update on one, updating it with values from one column in another table.