[Mapserver-users] multiple request in one layer

[Schlemmer Thilo]

Hi there, 


i want to get results from 2 tables in a mapfile-layer:


LAYER
    CONNECTIONTYPE oraclespatial
    CONNECTION "something/somewhere at else"
    NAME "STREETS"
    DATA "S.GEOM, P.GEOM from STREETS S, PATH P"
    STATUS off
    TYPE LINE
    FILTER "SHAPENAME like 'noidea'"
 CLASS
   EXPRESSION ...
   .
   .
   .
   
   ...but i receive the following error-message:
   
   "msOracleSpatialLayerWhichShapes(): Error parsing OracleSpatial DATA
variable. Must contain 'geometry_column from table_name|(SELECT stmt)'"
   
   I can't find any information about the request of multiple tables in the
documentation (or am i blind?).
   
   Any ideas?
   
   Thilo