Report Problem

Hi,

T_Master_Record

PNo. Data Amount

1 01/04/07 100

2 10/04/07 200

3 10/04/07 300

7 10/04/07 100

T_Trans_Record

PNo. Data Amount

1 01/04/07 50

2 10/04/07 60

1 10/04/07 70

2 10/04/07 20

1 10/04/07 30

T_Final_Record

PNo. Data Amount

1 01/04/07 165

2 10/04/07 200

3 10/04/07 300

7 10/04/07 100

Here I have Three Internal Table, I want to do,

1. If PNo of T_Master_Record present in table T_Trans Record then

Add amount of T_Master_Record with T_Trans Record. Like Add 100507+3 = 165.

And append in table T_Final Record.

2. If PNo of T_Master_Record not present in T_Trans Record then append that PNo. With Amount in T_Final_Record

How will I do this.

Thanks,

Saroj