AFAIK, you would have to write a loop.
>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
