I have two tables: TableA and TableB.
Table A :
| Id | Value |
|---|---|
| 0021 | Cell 2 |
| 0033 | Cell 4 |
| 0021 | Cell 1 |
| 0036 | Cell 6 |
Table B
| ID | Value |
|---|---|
| 0021 | Cell 8 |
| 0033 | Unknown |
I want to update the Value of ID in Table A based on the results of Table B : If TableB.Value like '
I have two tables: TableA and TableB.
Table A :
| Id | Value |
|---|---|
| 0021 | Cell 2 |
| 0033 | Cell 4 |
| 0021 | Cell 1 |
| 0036 | Cell 6 |
Table B
| ID | Value |
|---|---|
| 0021 | Cell 8 |
| 0033 | Unknown |
I want to update the Value of ID in Table A based on the results of Table B : If TableB.Value like '