Re: Updating Field value from Field in another table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks, that did the trick.

--
Gregory M. La Due
Twin Tiers Technologies, Inc.




"Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:ewY79cQeFHA.1136@xxxxxxxxxxxxxxxxxxxxxxx
> 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_@xxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
> news:U4%ue.53242$g5.25596@xxxxxxxxxxxxxxxxxxxxxxx
>>
>> 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.
>>
>>
>
>


.

Relevant Pages