You need a CrossTab for this. Check out FastXTab class in Downloads section here.

>how about this? i want to count all unique comid in table inout. so i try this,
>
>

select count(*), comid from inout group by comid

>
>which gives me,
>
>cnt comid
>1 01
>2 02
>1 04
>
>
>i want it to appear like,
>
>01 02 04
>1 2 1
>
>
>
>
>how will i be able to do that? is there any way i can make the column comid as field names?
>
>pls help. TIA.