[Mapserver-dev] MySQL feature data joins

[David Horowitz]

Hello all,

I'm writing an application which gets its spatial data from shapefiles but its feature data from a SQL data source (either MySQL or Oracle).  I have read the Wiki topic "JoinDatasources" but did not find its explanation of how to go about this sufficient.  Any help here would be appreciated.

To be more specific, I have all my data loaded into a MySQL database (using the shp2mysql tool).  Supposing the source shapefile is "statemap.shp" and the feature column I wanted to access in my database was called "title" what would my mapfile entry look like?  Is using a join the way to go about solving this problem?

Thanks in advance.