Skip to Content
0
Former Member
Feb 26, 2009 at 09:23 AM

Update table after join

42 Views

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