Get value from query to update another another table

#1

I have a query that simply slelcts the min value of a specified field
from one table, I want to take that value to update a field in
annother table, just can not figure it out.

#2

(rzito (AT) si (DOT) rr.com) writes:

Quote:

I have a query that simply slelcts the min value of a specified field
from one table, I want to take that value to update a field in
annother table, just can not figure it out.

UPDATE tbl
SET col = (SELECT MIN(somecol) FROM othertbl)
WHERE ...

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Get value from query to update another another table

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Get value from query to update another another table - 10-26-2007 , 03:04 PM

Re: Get value from query to update another another table - 10-26-2007 , 04:35 PM