Plz Help in OGR and MYSQL
Frank Warmerdam
warmerdam at POBOX.COM
Thu May 4 06:04:31 PDT 2006
grabiel wrote:
> connectiontype ogr
> connection "n_state.shp"
> DATA "SELECT * from nsdata left join 'MYSQL:test,
> host=localhost, user=root'.nsdata ON n_state.st_nm=nsdata.name"
> END
> END
>
Grabriel,
I think you want:
SELECT * from n_state LEFT JOIN ...
The n_state player (from the shapefile) is the primary table.
You should be able to test the left join from ogrinfo as well using
the -sql command option.
Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | President OSGF, http://osgeo.org
More information about the MapServer-users
mailing list