Hey guys, So I have two look up tables table1 and table 2. Table 1
ID Username Fname Lname
Table 2
Username What i want to do is have my search result look like this ID, Username(from table one), Fname, Lname, Username(table two)
54, User1, John, Smith, User1 The reason i want it to do that is because i want to compare the username from table 1 to table 2 so that i can know the user is missing from the source we're getting the table 2 from. I was able to get append to work but the issue i run into is it wont place the usernames in the same row. It shows all the values for table one fills the columns and then shows all the values for table 2 with the table one columns. Ex: ID, Username(from table one), Fname, Lname, Username(table two)
54, User1, John, Smith, (blank)
55, User2, Jane, Smith, (blank)
(blank),(blank),(blank),(blank),User1
(blank),(blank),(blank),(blank),User2 I just want the usernames from table 1 to match and be in the same row as the username in table2
... View more