dalavouras
New Member
- Joined
- Feb 17, 2017
- Messages
- 8
TABLE A
TABLE B
How do we update values in Table A using the Values of Table B and keep the rest as they are?
| SiteId | date | Value 1 | Value 2 | Value 3 |
| 1 | 1-1-2020 | 5 | 20 | 500 |
| 1 | 2-5-2020 | 6 | 60 | 100 |
| 3 | 1-1-2021 | 2 | 85 | 250 |
| 5 | 1-1-2020 | 6 | 14 | 566 |
TABLE B
| SiteId | date | Value2 |
| 1 | 1-1-2020 | 25 |
| 3 | 1-1-2021 | 73 |
How do we update values in Table A using the Values of Table B and keep the rest as they are?
