I have a MySQL datastore on GeoServer.
My MySQL database contains both spatial and non spatial data in separate tables.
Now, I want my web client to request for an WFS. To respond to that service, Geoserver needs to join two tables, one spatial and other non spatial and return the query result.
Geoserver by default always queries the table containing spatial data.
How can I request WFS to make such a hybrid query ?
Moreover, based on the query result, I want create a dynamic SLD for my base map.
Any clue?
Regards,
Suvajit
My galleria @ http://www.flickr.com/photos/jeet_sen