I have three tables, Table 1, 2 and 3. Each table has a field in it called name. What I want to do is: If the name in table 1 is not in Table 3, add it. If the name is in both Table 3 and Table 2, import the value of points into table 3, if it is not in table 3, add it.
I hope this makes sense. Table 1 and 2 have people's names and the points they got. Table 3 has their name and a column for points from Table 1 and a column for points for Table 2.
Any suggestions on making this work?