Thematic classification of joined table field

[Stephen Woodbridge]

Παρασός Δημήτρης wrote:
> Hi everyone!!
> 
> I'm a  new ms4w mapserver user. I need to develop a web map application, 
> serving
> one shapefile
> joined with an MS SQL Server flat table.
> The polygon shapefile has a 1-1 relationship with the DB table.
> I need to have the polygon shapefile thematic classified based on a
> joined table field. So far I managed to install/create mapfile/create new
> map service/perform the join/deploy new map sites using FIST. So
> I have a working map service but I'm stuck in displaying the polygons 
> classified
> based  on the joined attributes.
> 
> Is thematic classification based on joined field values supported?
> 
> thanks in advance
> Dimitris Parasos
> Rhodes-Hellas

Dimitris,

Mapserver has NO native join support when rendering a shapefile.

The ideal way to do this is via PostGIS.

Another option might be using JOINs in OGR, OGR is part of the GDAL 
library and tools.

-Steve W