Using query results in another query

I am trying to generate a report to look at specific contracts. The first section uses NL rows to list the sales order lines.

The second section is to run a NL Rows for all production orders for the items listed by the first sections. 

What is the best way to do this?

1 comment

Please sign in to leave a comment.