[GRASS-user] How to JOIN a table to vector layer using MySQL

[Raffaele Morelli]

2006/11/9, Moritz Lennert <mlennert at club.worldonline.be>:
>
>
> This might be an issue with layers, not with your view.
> How do you use the layers ? Layers can be quite complex to understand
> and there has been much discussion on them.
>
> Have you tried connecting to a view without changing layers, i.e.:
>
> - take a map MyMap for which you have a table MapTable in your database
> - create a view with "create view NewView as select * from MapTable"
> - connect your map to this view with '
>
> Do you have problems showing labels or querying the map ?


(...!!!...)  ok, this works. But now I have some questions about it.

"v.db.connect -o map=MyMap table=TABLE key=KeyCol driver=mysql
database=grass layer=2"
this connects my map with a static table on layer 1

"v.db.connect -o map=MyMap table=NewView key=KeyCol driver=mysql
database=grass layer=1"
this connects my map to the view

in this panorama, if I try to query (using gis manager) setting "Layer for
labels" = 2 and indicating the col field in the view I don't see anything.
Why? Am I missing something?

raffaele
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20061109/91fcb8ad/attachment.html