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