O.K.:
The following syntax for a ogr2ogr dbf LEFT JOIN works:
ogr2ogr -sql "SELECT AREASYMBOL, MUKEY, DRCLASSDCD FROM soils LEFT JOIN
'master.dbf'.master ON soils.MUKEY = master.MUKEY" outshpdir soils.shp
Thanks to all for your help in figuring this o
e Jet driver has an 8.3 filename limitation ... so it
creates other problems and additional work.
OGR2OGR has proved very powerful for many other tasks. If I can get to also
do DBF joins, I can perform all of necessary shapefile operations in one
step.
Thanks,
Kris R. DeLaney
- Original Me
Re: GDAL 1.6.0, released 2008/11/26
I have be unable to use OGR2OGR to accomplish an SQL LEFT JOIN of a shapefile
with the attributes of a master dbf table. If my syntax is not correct, I hope
someone can show me where it is wrong.
The files I am using are all in the same directory. I have t
