Updating Field value from Field in another table
This is a discussion on Updating Field value from Field in another table within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Is there a where to Update the Value of a Field in one table to a Field Value from ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:46 PM
| ||||
| ||||
 Updating Field value from Field in another table Is there a where to Update the Value of a Field in one table to a Field Value from another table. The following works in MS Access but I am unsure on how to do the same in SQL 2000 UPDATE [ci_CaseData] INNER JOIN [ci_Addresses] ON [ci_CaseData].[CaseGUID] = [ci_Addresses].[CaseGUID] SET [ci_CaseData].[NameGUID] = [ci_Addresses].[AddrGUID] -- Gregory M. La Due Twin Tiers Technologies, Inc.      |
|
02-27-2008, 09:46 PM
| |||
| |||
| Re: Updating Field value from Field in another table Its Update SomeTable Set Col1 = T2.Col5 FROM SomeTable T1 Inner join SomeOtherTable T2 ON T1.IDCol = T2.IdCol HTH, Jens SUessmeyer. "Greg" <gml_nospam_@twintierstech.com> schrieb im Newsbeitrag news:U4%ue.53242$g5.25596@twister.nyroc.rr.com... > > Is there a where to Update the Value of a Field in one table to a Field > Value from another table. > > The following works in MS Access but I am unsure on how to do the same in > SQL 2000 > > UPDATE [ci_CaseData] INNER JOIN [ci_Addresses] ON [ci_CaseData].[CaseGUID] > = [ci_Addresses].[CaseGUID] SET [ci_CaseData].[NameGUID] = > [ci_Addresses].[AddrGUID] > > > > -- > Gregory M. La Due > Twin Tiers Technologies, Inc. > > |
|
02-27-2008, 09:47 PM
| ||||
| ||||
| Re: Updating Field value from Field in another table Thanks, that did the trick. -- Gregory M. La Due Twin Tiers Technologies, Inc. "Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.d e> wrote in message news:ewY79cQeFHA.1136@TK2MSFTNGP12.phx.gbl... > Its > > Update SomeTable > Set Col1 = T2.Col5 > FROM SomeTable T1 > Inner join SomeOtherTable T2 > ON T1.IDCol = T2.IdCol > > HTH, Jens SUessmeyer. > > > "Greg" <gml_nospam_@twintierstech.com> schrieb im Newsbeitrag > news:U4%ue.53242$g5.25596@twister.nyroc.rr.com... >> >> Is there a where to Update the Value of a Field in one table to a Field >> Value from another table. >> >> The following works in MS Access but I am unsure on how to do the same in >> SQL 2000 >> >> UPDATE [ci_CaseData] INNER JOIN [ci_Addresses] ON >> [ci_CaseData].[CaseGUID] = [ci_Addresses].[CaseGUID] SET >> [ci_CaseData].[NameGUID] = [ci_Addresses].[AddrGUID] >> >> >> >> -- >> Gregory M. La Due >> Twin Tiers Technologies, Inc. >> >> > > |
Linear Mode
