Merging Rows with Common ID from different Tables

[anshpalash]

Hi all,

I have three tables of the form:

ID	Location
11	NY
12	DL
13	IN
14	TX
17	NY

ID	Weight
11	1
12	2

ID	Lot
17	2123

I am looking to achieve this:

ID	Location	ID Match	Weight	Lot
11	NY	11	1	null
12	DL	12	2	null
13	IN	null	null	null
14	TX	null	null	null
17	NY	17	null	2123

I have created a relationship set up between the ID columns of the three tables. I want to add those rows from the second and third tables to the first table that have a matching UID. 

I tried using the related function for the second table. But since I can only have one active relationship, I am not able to do the same for the third table.

Can anyone please give me any direction on how I can add rows from different tables to the first one that have a matching ID? Thanks!

[v-henryk-mstf]

Hi @anshpalash ,

Whether the advice given by @VahidDM  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[VahidDM · Accepted solution]

Hi @anshpalash 

Please download the sample file attached.

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[Ashish_Mathur]

Hi,

Use the Merge Queries feature of the Query Editor.