How create a hierarchy from multiples tables?

I have two querys:

Items in Stock: 

Date:

And I need automate this result:

Anyone can help-me, please? How can I do it?