[GRASS-user] populate a table with values from another one

Moritz Lennert mlennert at club.worldonline.be
Wed May 28 17:37:50 EDT 2008

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 ?


More information about the grass-user mailing list