Join shape and dbms data: OGR?

[Michael Schulz]

Dear List,

i want to evaluate the possibility to integrate a layer in mapserver, that takes the geometry data
from a shape file (polygons with a unique id) and the attribute data from a MS-Access DB (this is
unfortunately a precondition). The attribute data should be joined with the shape-file unique
polygon id and thus accessible for classification and labeling.

I looked through the OGR connection possibilities and now i am wondering if this could be achieved
using an OGR virtual datasource, which has a SQLSrc defined that performs the join?

Thanks, Michael

--
-----------------------------------------------------------
Michael Schulz                                in medias res
Dipl.-Geologe                              Gesellschaft für
                                 Informationstechnologie mbH
                                      In den Weihermatten 66
                                             79108 Freiburg
                                      0761 55695-95 (Fax 96)
mschulz at webgis.de              www.webgis.de/www.zopecms.de