Forum Discussion
DarylRob
Helper I
4 years agoTake 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
- amitchandak
Super User
- DarylRob
Helper 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?