How create a Query Hierarchy from Multiple 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?