I have tabels like this..
| id | code | Name | Quantity |
|---|---|---|---|
| 1 | A1 | ABC | 10 |
| 2 | A2 | BCD | 20 |
| 3 | A1 | ABC | 30 |
| 4 | A1 | ABC | 10 |
| 5 | A3 | EDC | 30 |
i want to decrese quantity with this tabel..
| code | Name | Quantity |
|---|---|---|
| A1 | ABC | 45 |
| A2 | BCD | 5 |
then i want the result like this.
| id | code | Name | Quantity |
|---|---|---|---|
| 1 | A1 | ABC | 0 |
| 2 | A2 | BCD | 15 |
| 3 | A1 | ABC | 0 |
| 4 | A1 | ABC | 5 |
| 5 | A3 | EDC | 30 |
i have no idea for this case. thanks..
