[GRASS-dev] problem with sql query

[Dylan Beaudette]

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