Ed Dressel wrote:

> I need to move data (e.g PhoneNumber) from one table (ClientInfo) to a
> different table (e.g. PersonInfo) with a common ID (Client_ID) field
> and a condition on the destination table (PersonType=0).
>
> ClientInfo:Client_ID PhoneNumber --> PersonInfo:Client_ID,
> PersonType=0, PhoneNumber
>
> Is there a way to do this with a SQL statement, or do I need a stored
> proc?
>
> Thanks
> Ed Dressel
>

Insert into PersonInfo (Client_ID, PersonType, PhoneNumber) select
Client_ID, 0, PhoneNumber from ClientInfo

see you !

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