Oracle Multitable Join

[Fernando Simon]

Hi Christopher,
You can do this query using a DATA parameter like:
DATA "shape FROM (SELECT p.SHAPE, p.NAME FROM POINTS p, AREAS a WHERE 
a.NAME = ‘California’ AND SDO_FILTER(p.shape, o.shape, ‘querytype = 
WINDOW’) = ‘true’) USING NONE"
You can see more details about Oracle Spatial and Mapserver integration 
in this link:
"http://mapserver.gis.umn.edu/docs/howto/oracle_spatial_howto"
Best regards.


------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://www.univali.br/g10 - UNIVALI/CTTMAR
------------------------------------------------------------------------


Christopher Condit wrote:
>
> Is it possible to use multiple relations when adding an native oracle 
> connection? I want to use something like this, but can’t quite figure 
> out how:
>
> SELECT p.SHAPE, p.NAME FROM POINTS p, AREAS a WHERE a.NAME = 
> ‘California’ AND SDO_FILTER(p.shape, o.shape, ‘querytype = WINDOW’) = 
> ‘true’
>
> The idea is that I’ve got two Oracle spatial tables, one with points, 
> the other with polygons. Given a polygon from the latter, I want all 
> the points appearing in it to be drawn on the map. Is this possible 
> with the existing Oracle spatial implementation? How would my DATA 
> definition look?
>
> Thanks,
>
> Chris
>