Thanks Peter- it's "like" a join but not quite- one typically does a join if there are extra variables to capture; these tables are identical in structure/size. Data in Table_1 is just more reliable than the other (but is comparatively sparsely populated).
I wan't to "superimpose" the two tables such that data from Table 1 is given priority over Table 2.
There could be situation where Mark's age in Table_1 is 85- in that case I would like the output to read:
Table 1 Table 2 Table 3
Record Name Age Record Name Age Record Name Age
4 85 4 Mark 45 4 Mark 85
There's gotta be a way to do this! Thanks again for looking into this.