[GRASS-user] SQL and GRASS

GRASS GRASS user
1

GRASS is connected to a MySQL data base

I want to select polygons which are not 0
so do I do:

d.vect SiteGrid3 where "SquareNumber<>0 "
or
v.db.select map=SiteGrid3 column=square_no where=<>0

I have a second non spatial table described below(right)

grass SiteGrid3 (one) Pottery table (many)
|cat|SquareNumber| |SquareNumber|Type|
|1 |1 | |1 |mug |
|2 |2 | |1 |mug |
|3 |3 | |1 |mug |
it continues...

so now I want to select the square number but be able to use v.what to
return the amount of pottery.

Any ideas? This is easy in sql but I want to show it in GRASS

Thanks

Gary

--
View this message in context: http://n2.nabble.com/SQL-and-GRASS-tp4690410p4690410.html
Sent from the Grass - Users mailing list archive at Nabble.com.