How to combine table 2 value in table 1 where id field is same?

-1 votes

1 answer

253 views

                          Table 1

| id    | name  | coupn |
| ----- | ----- | ----- |
| PR001 | DC001 | 5     |
| PR002 | DC001 | 5     |
| PR003 | DC001 | 6     |
| PR004 | DC002 | 7     |
| PR005 | DC003 | 3     |
| PR006 | DC003 | 11    |
| PR007 | DC004 | 10    |
| PR008 | DC005 | 66    |

Table 2

| id    | name | bonus |
| ----- | ---- | ----: |
| PR001 | res  |    10 |
| PR002 | des  |     2 |
| PR003 | DC   |     1 |
| PR004 | Drf  |     7 |
| PR005 | wed  |     3 |


                        

Asked by Rk Itsolution (1 rep)

Feb 19, 2020, 07:42 PM
Last activity: May 27, 2025, 05:43 AM

How to combine table 2 value in table 1 where id field is same?

Related Questions