select
clip.RiskStateId,
clim.DistributionSource as DistributionSource,
Field1 ,
field2,
Field3,
Field4
from
cli.policy as clip , cli.METLIFEPOLICY as clim
where
YEAR(clip.Expdt)= 2004
and MONTH(clip.Expdt)= 6
and clip.riskcheck=1
and field1=clim.IDnum
group by clip.riskStateId, clim.DistributionSource
I need to report like
RiskStateId
|
|
|--- Distribution Sources
| 1. Field1 Field2
| 2. Field1 Field2
| 3. Field1 Field2
|--- Distribution Sources
| 1. Field1 Field2
| 2. Field1 Field2
| 3. Field1 Field2
Can any one suggest me how to go?