On 27/05/08 20:59, Glynn Clements wrote:
Manuel Sangiao wrote:
someone knows why this statement doesn't work?
echo "UPDATE grenzen gr SET gr.cleft=(SELECT adm.NAME FROM myadm0 amd WHERE gr.left=
adm.cat)" | db.execute
Which database back-end are you using? The DBF driver only understands
a fairly limited subset of SQL; in particular, it doesn't support
subselects.
And just as importantly, AFAIK, it does not support the use of more than
one table in a statement, or ?
Moritz
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user