My database is postgres/postgis (pg)
error message :
error's synthaxe when i write whitout "." for query only one table
there's no error
quentin
Dylan Beaudette a écrit :
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
_______________________________________________
grass-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-dev
