[Mapserver-users] query on an extern db

[Schnider Markus]

Hi all,

Is it possible to query on a extern db?
How is it possible?

The geo-data are in a ArcSDE.
The feature information stored in the ArcSDE is only a ID.
This ID also stored in a Oracle DB.
The Oracle DB contains the whole information. (non spatial !)
There have to be a join other these two datasources!

I have read that it is possible to join other dbf files with the OGR library.
e.g.: CONNECTION 'spmap.dgn,SELECT * FROM elements'

Markus Schnider