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

Glynn Clements glynn at gclements.plus.com
Thu May 29 11:59:25 EDT 2008

Moritz Lennert 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 ?

Right; it doesn't support joins (or aliases).

IOW, the DBF back-end is a simple flat-file database, not a relational

Glynn Clements <glynn at gclements.plus.com>

More information about the grass-user mailing list