table-1: student
| id_admission | student_name |
|---|---|
| 101 | noman |
| 102 | musfik |
| 103 | tousif |
table-2: result
| id_admission | average | exam_name |
|---|---|---|
| 101 | 85.20 | 1st exam |
| 102 | 65.24 | 1st exam |
| 103 | 65.24 | 1st exam |
| 101 | 55.20 | 2nd exam |
| 102 | 65.24 | 2nd exam |
| 103 | 65.24 | 2nd exam |
| 101 | 75.20 | 3rd exam |
| 102 | 65.24 | 3rd exam |
| 103 | 65.24 | 3rd exam |
now I want to display in report:
| id_admission | student_name | 1st exam | 2nd exam | 3rd exam | g_average |
|---|---|---|---|---|---|
| 101 | noman | 85.20 | 55.20 | 75.20 | 71.76 |
| 102 | musfik | 65.20 | 65.20 | 65.20 | 65.20 |
| 103 | tousif | 85.20 | 55.20 | 75.20 | 71.76 |