Need help!
I have two tables with 5 columns each. The first two columns in both tables contain ID#s and Names. The third column contain job titles in both tables. Table 2 has many more records that table1 - in other words table 1 is a subset of table 2.
I want to compare these titles in the two tables and identify which ones are different. If they differ, I want to be able to insert the titles from table 1 into table 2, column 6.
Many thanks!
I have two tables with 5 columns each. The first two columns in both tables contain ID#s and Names. The third column contain job titles in both tables. Table 2 has many more records that table1 - in other words table 1 is a subset of table 2.
I want to compare these titles in the two tables and identify which ones are different. If they differ, I want to be able to insert the titles from table 1 into table 2, column 6.
Many thanks!