Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
Hi Friends,
Can any one help me in this
Thanks in advance
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |