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?