Combining two datatable and getting the amount from second table by using linq
I have two tables as shown below.
the result table looks like this.
I wish to finish this within 1 linq statement. (if totally impossible, 2 statements)
I have worked my statement this far.
That statement will combine 2 tables, but I dunno how to continue to count the for the quantity.
If I must use a second query, It has been done.
Query to work with