I have 2 tables:

SchdLine and Details. There is a One To Many relationship from SchedLine
into Details

SchedLine has a Length field. Details has a Type field.

Each SchedLine record could have multiple child records in Details with
different Type values.


The result set should look like:

  Length         Type
  ----------------------
  30             1
  30             2
  30             3
  .
  .
  .
  30            16
  60            1
  60            2
  60            3
  .
  . 
  .

and so on.

Each record in the result set should contain a count of each type from
Details against each Length in SchdLine.

Hope that explains it.

Thanks