• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data base consolidation

B

bluetaurean

Member
I have two tables like

1st table - to make a produce i need components a, b,c

Item;Qty

a;5

b;2

c;4


In turn component c needs another 3 items aa;ab;ac

2nd table

c;aa;2

c;ab;3

c;aa;4


I need to combine the two tables to get the total components needed like

a;5

b;2

aa;8

ab;12

aa;16
 
You must log in or register to reply here.
Back
Top