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, [EMAIL PROTECTED]
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | President OSGF, http://osgeo.org
