Unfortunately, you cannot use UPADTE SQL Where clause to join tables. If you have compound index on the suniq and ident fileds than you can set relation from TableA to TableB and use REPLACE command to update TableA. Something like

SET ORDER TO < compound index on the suniq and ident fileds > IN TableA 
SELECT TableB
SET RELATION TO suniq + ident INTO TableA 
REPLACE FOR FOUND("TableA") ...

Or you can use SCAN

SELECT TableA
SCAN
  UPDATE TableB SET ... ;
     WHERE TableB.suniq = TableA.suniq AND TableB.ident = TableA.ident
ENDSCAN

Remember that expression in the WHERE clause doesn't join TableB and TableA but uses values from the current records in the TableA.

>Hello group,
>
>Is it possible to update the records in table b from table a. They would be linked by suniq and ident
>
>so something like
>
>update b
>set *
>where a.suniq = b.suniq and a.ident = b.ident
>
>I am not new at this but I do it so infrequently that I don't have a good understanding of it.
>
>Thanks
>Jim