Ed Dressel wrote:

>> Insert into PersonInfo (Client_ID, PersonType, PhoneNumber) select
>> Client_ID, 0, PhoneNumber from ClientInfo
>>
>
>
> Thanks Alexandre--but I need to clarify.
>
> The record in the destination table will already--I just need to move
> the data to the existing record.
>
> I'm thinking I need a stored proc. Right?
>
>

Update
PersonInfo P
set
P.PhoneNumber = (Select C.PhoneNumber from ClientInfo C where
C.Client_ID = P.Client_ID)

see you !


--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br