:o))

UPDATE Temp3 SET ClientName = ALLTRIM(Client.ClientId) + " - " + Client.Cl_Name
       WHERE Temp3.ClientId = Client.ClientId

** or
UPDATE Temp3 SET ClientName = ALLTRIM(Client.ClientId) + " - " + Client.Cl_Name
       FROM Temp3 INNERT JOIN Client ON Temp3.ClientId = Client.ClientId

** or if you want all fields in table3 to be updated, no metter if there are macthing records in Client (i doubt about it)
UPDATE Temp3 SET ClientName = NVL(ALLTRIM(Client.ClientId) + " - " + Client.Cl_Name, '')
       FROM Temp3 LEFT JOIN Client ON Temp3.ClientId = Client.ClientId

>I'm using VFP9.
>
>Corrected:
>
>

>SELECT Temp3
>SCAN
>				
>    =SEEK(Temp3.ClientId, "Client", "ClientId")
>
>    REPLACE IN Temp3 ;
>       ClientName WITH ALLTRIM(Client.ClientId) + " - " + Client.Cl_Name
>       NEXT 1
>
>END SCAN
>

>
>
>>>How can I use a JOIN to update instead of:
>>>
>>>

>>>SELECT Temp3
>>>SCAN
>>>				
>>>    **=SEEK(TempJoin.ClientId, "Client", "ClientId")
>>>    =SEEK(Temp3ClientId, "Client", "ClientId")
>>>
>>>    REPLACE IN Temp3 ;
>>>       ClientName WITH ALLTRIM(Client.ClientId) + " - " + Client.Cl_Name
>>>       NEXT 1
>>>
>>>END SCAN
>>>

>>
>>Hey, from where TempJoin comes from?
>>BTW what version of VFP you use?