I have a couple of different sql queries that each in their own right give me what I need. But I would like to merge the two together as one report.
Is it possible to have an outer select with an inner select?
The first select is returning an ID. On the second (inner) select I would like to pass in the ID from the outer select.
How could I do this?