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

[Dylan Beaudette]

On Wednesday 08 November 2006 12:33, Jarek Jasiewicz wrote:
> Nicolas Devaux napisał(a):
> > Hi, I'm using Grass 6.0 (I will use 6.2 soon, but I need to go further
> > with 6.0 version until one month).
> > I would like to join a vector table with external attribute table
> > using MySQL.
> > I created the MySQL Database, and did the v.dbconnect with MySQL drivers.
> > I did the Join operation with Mysql and it works perfectly. But, when
> > I come back in Grass, it is not possible to see the result within the
> > attribute table... Joined attributes are not in the table. It seems
> > that grass is not able to see results of the joined operation made in
> > Mysql.
> >
> > Does some body has any suggestion ?
> >
> > To resume my problem, I can say that I just try to do a join operation
> > on vector attribute table, and that this operation seems to be a
> > little bit difficult with Grass.
> >
> > Thanks
> >
> > --------------------------------------------------------
> >
> > _______________________________________________
> > grassuser mailing list
> > grassuser at grass.itc.it
> > http://grass.itc.it/mailman/listinfo/grassuser
>
> well grass not see joined tables. the only way as I thing is to use SQL
> command CREATE TABLE nova AS
> SELECT a.cat ..... FROM a INNER JOIN b ON .......;
> nad reconnect vector to nova table (a.cat MUST be in SELECT section)
> I use it very ofen but... on PgSQL. I'm not sure if CRATE TABLE AS works
> on mysql
>
> regards
> Jarek
>

it should work.

-- 
Dylan Beaudette
Soils and Biogeochemistry Graduate Group
University of California at Davis
530.754.7341