On Tuesday 30 June 2009, Quentin Page wrote: > I try to interview two vectors with tables with SQL query. > > when I write : > > echo "update table table1 set attribute1 = 1 where table1.attribute2 = > table2.attribute2" |db.execute > > I receive an error message. Is there a syntax error with the point > between tables and attributes? > > Any idea? Can I use sql query to interview two tables in the > same time? >
What is the database back-end? As far as I know, you cannot use update statements like this with the DBF back-end. Dylan -- Dylan Beaudette Soil Resource Laboratory http://casoilresource.lawr.ucdavis.edu/ University of California at Davis 530.754.7341 _______________________________________________ grass-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-dev
