Forum Discussion

DarylRob's avatar
DarylRob
Icon for Helper I rankHelper I
4 years ago

Take distinct values from two different columns in two different tables and create a new table

Hi, 

 

So I've got two tables both with Account Manager columns, for example

 

Table 1:

Gary

Gary

Dave

Terry

Billy

Billy

 

Table2:
Jenny

Jenny

Dave

Billy

 

And i want to then create a new table with:

Gary

Dave

Terry

Billy

Jenny

 

I've tried using summarize and distinct but to no avail...

 

2 Replies

    • DarylRob's avatar
      DarylRob
      Icon for Helper I rankHelper I

      Perfect, thanks. But now i'm trying to create a relationship between the two fields but it won't create a many-to-one relationship instead only able to create a many-to-many. Any ideas?