Hello Dear Experts
I have made the program with simple join:
REPORT XXX.
Tables: AAA, BBB, CCC, DDD.
select single
b~field2
c~field3
a~field1
into (DDD-field4, DDD-field5, DDD-field6)
from AAA AS a
INNER JOIN BBB AS b ON afield1 = bfield2
AND afieldx = bfieldx
INNER JOIN CCC AS c ON afield1 = cfield1
AND afieldx = cfieldx
WHERE a~fieldx = 'A'.
update CCC from CCC.
commit work.
The question is, how can I update the table CCC after the join is made?
Regards
Robert