Posted by Erland Sommarskog on 10/26/07 21:35

(rzito@si.rr.com) 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@sommarskog.se

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

• Next in forum: Re: ODBC Failed [Microsoft][ODBC SQL ...NamedPipes]ConnectionWrite (WrapperWrite()).
• Prev in forum: Re: Uploading image type using TSQL
• Thread view: Re: Get value from query to update another another table

[Reply to this message]