[GRASS-user] populate a table with values from another one
Glynn Clements
glynn at gclements.plus.com
Tue May 27 14:59:57 EDT 2008
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.
--
Glynn Clements <glynn at gclements.plus.com>
More information about the grass-user
mailing list