asked on

Help with SQL statement

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?

Thanks

dhanushkad

Code you please explain it more..

dhanushkad

Could you please explain your question with some samples..

greddin

ASKER

First first select statement returns a list of CollectionIDs Like this:
 
CollectionID
------
1
2
3
4
5
and so on
 
My second query does takes a given CollectionID and counts a DocType that are in each CollectionID.
 
Like this:
 
DocType   Total
-------   -----
 type1      12
 type2       6
 type3       8
 type4       2
 type5      16
 
I would somehow like to merge these two results into one and return something like this:
 
CollectionID  DocType  Count
------------  -------  -----
     1         type1     12
     1         type2      6
     1         type3      8
     1         type4      2
     1         type5     16
     2         type1      2
     2         type2     10
     2         type3      5
     2         type4      3
     2         type5      9
..continue until all CollectionIDs are done.
 
Does this make sense?

Open in new window

ASKER CERTIFIED SOLUTION