Re: Get value from query to update another another table
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 26 Oct 2007 21:35:02 +0000 (UTC)
(rzito@xxxxxxxxx) writes:
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@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Prev by Date: Re: Uploading image type using TSQL
- Next by Date: Re: ODBC Failed [Microsoft][ODBC SQL ...NamedPipes]ConnectionWrite (WrapperWrite()).
- Previous by thread: Get value from query to update another another table
- Next by thread: Uploading image type using TSQL
- Index(es):
Relevant Pages
|
