Table 1 ID | Country |
1 | United States |
2 | United States |
3 | United States |
<colgroup><col><col></colgroup><tbody>
</tbody>
Table 2
ID | Final Region | Sub-region | user |
1 | Americas | United States | 5 |
2 | Americas | canada | 3 |
3 | Americas | Latin America | 1 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I need to bring in "User" col from table 2 to table 1, when ID matches in both tables but when sub-region in Table 2 is "United States" |
<tbody>
</tbody>