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

[Manuel Sangiao]

Hi,

sorry to reply so late.

I'm using DBF als back-end database. I will try it with sqlite.

Thanks



2008/5/29, Glynn Clements <glynn at gclements.plus.com>:
>
>
> 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
> database.
>
>
> --
> Glynn Clements <glynn at gclements.plus.com>
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20080530/dce80a6a/attachment.html