[GRASS-user] v.db.join question

[Johannes Radinger]

Hi,

does anyone have an idea what I should test to get my join working?

/johannes

On Tue, Feb 12, 2013 at 4:15 PM, Johannes Radinger
<johannesradinger at gmail.com> wrote:
> Hi,
>
> I try to join a vector attribute table (points, sqlite-db) with
> another sqlite table that is already imported to GRASS.
> Both tables share some columns and have a column called AB_ID as
> unique identifier (key to join).
>
> I opened the sqlite database with the SQLite Manager (Firefox) and can
> successfully perform a simple query:
> SELECT * FROM Vector_1, Table_2 WHERE Vector_1.AB_ID=Table_2.AB_ID
>
> however when I want to join the tables in GRASS using v.db.join the
> new columns (*_other) are empty for all rows:
> v.db.join -a map="Vector_1" column="AB_ID" otable="Table_2" ocolumn="AB_ID"
>
> As some of the columns have the same names in both tables I used the 'a'-flag.
>
> What I am doing wrong? I am working with GRASS65 (rev 55016) on Ubuntu 12.04.
>
> /Johannes