>
> 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.
>
>

> 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.
>>
>>
>
>