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 <[EMAIL PROTECTED]> _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
