[TABLE="width: 165"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Table 1
ID[/TD]
[TD]
Country[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]United States[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]United States[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]United States[/TD]
[/TR]
</tbody>[/TABLE]
Table 2
[TABLE="width: 273"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD]Final Region[/TD]
[TD]Sub-region[/TD]
[TD]user[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Americas[/TD]
[TD]United States[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Americas[/TD]
[TD]canada[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Americas[/TD]
[TD]Latin America[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 152"]
<tbody>[TR]
[TD="width: 152"]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"[/TD]
[/TR]
</tbody>[/TABLE]
PLEASE HELP!
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Table 1
ID[/TD]
[TD]
Country[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]United States[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]United States[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]United States[/TD]
[/TR]
</tbody>[/TABLE]
Table 2
[TABLE="width: 273"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD]Final Region[/TD]
[TD]Sub-region[/TD]
[TD]user[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Americas[/TD]
[TD]United States[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Americas[/TD]
[TD]canada[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Americas[/TD]
[TD]Latin America[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 152"]
<tbody>[TR]
[TD="width: 152"]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"[/TD]
[/TR]
</tbody>[/TABLE]
PLEASE HELP!