[Chameleon] problems joining shp file to database with OGR

Normand Savard nsavard at mapgears.com
Tue Jan 15 15:48:01 EST 2008

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


More information about the Chameleon mailing list