Re: CROSS-TAB query help? I have read it cant be done in on

Theo Galanakis wrote:
> Thanks Rickard 
> Max may not work as not all the data is numerical. However I will give the
> contrib/cross-tab a go!

It will work as long as you only have one non-null value per grouped 
field (which you did in your example).

>>|     symbol     | linktype
>>-------------------+------+------+-------------------+-----------+----
>>-------------------+------+------+-------------------+-----------+----
>>-------------------+------+------+-------------------+-----------+--
>>            100473 | 93   |      |                   |           |
>>            100473 |      | 77   |                   |           |
>>            100473 |      |      | text1            |           |


--   Richard Huxton  Archonet Ltd