[Chameleon] problems joining shp file to database with OGR

[Normand Savard]

JBaum at townofbethlehem.org wrote:

>I did, and found that only the tables, not the views are available.  Its
>the view I was after.
>
>This leads me to a second question.  Is it possible in my SQL statement in
>the .map file (or .ovf) to have a complex SQL query with joins and so on?
>
>How would I construct that in order to be able to join to the key field in
>the .shp file?
>  
>

It seems that there is a limited form of join.  See 
http://www.gdal.org/ogr/ogr_sql.html pointed out by
http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?VirtualSpatialData

Norm