Joining Two Table with impact of first Data

[nksahay]

Hi,

I am using two table one table data is 

this is the correct sales value

Customer_Code	CustomerName	ItemCode	ItemName	Sum(Qty)	Sum(Amount)
0001	a	p001	f	10	200
0002	b	p002	g	10	200
0003	c	p002	h	20	300

Second table just have an information that requred to marge to first table

bomitem	Item Name	Product BOM	UOM
p001	f
		t	1
		y	1
		u	1
	g
		r	1
		t	1
		u	1
	h

when i marge this two table it give me a result of 

Customer_Code	CustomerName	ItemCode	ItemName	Product BOM	Sum(Qty)	Sum(Amount)
0001	a	p001	f	t	10	200
			f	y	10	200
			f	u	10	200
0002	b	p002	g	r	10	200
			g	t	10	200
			g	u	10	200
0003	c	p002	h		20	300

But correct result after marging shoud be 

Customer_Code	CustomerName	ItemCode	ItemName	Product BOM	Sum(Qty)	Sum(Amount)
0001	a	p001	f	t	10	200
			f	y
			f	u
0002	b	p002	g	r	10	200
			g	t
			g	u
0003	c	p002	h		20	300

Kindly help to get this resolved 

[v-jayw-msft]

Hi @nksahay ,

You could try merge queries feature with right outer join as below.

The problem is the product for item f is blank, why it will be "t" in the result?

Best Regards,

Jay

[nksahay]

Hi Friends,

Can any one help me in this

Thanks in advance