Hello,
I am trying to do a simple inner join on two tables (both dbf and in the same directory)
tenn_county_all_b
ddistance
useing key STFID and BgID
but I keep getting error
Error in db_execute_immediate()
I looked up error and I made sure db.tables -p gives me tables I expect to see.
It does so now I don’t why I keep getting error. I don’t think it is SQL syntax.
Thanks
Matthew
Windows Live: Make it easier for your friends to see what you’re up to on Facebook. Find out more.
On Wed, Sep 2, 2009 at 8:43 PM, Matthew Mulbrandon<mulbran@hotmail.com> wrote:
Hello,
I am trying to do a simple inner join on two tables (both dbf and in the
same directory)
tenn_county_all_b
ddistance
Matthew,
AFAIK joins are not supported with DBF. You could use the SQLite
driver to do this.
- make a new mapset
- run db.connect to define SQLite as default backend (see db.connect manual)
- g.copy the maps from the original mapset and GRASS will convert the
tables into SQLite
- do the join [1]
Of course also PostgreSQL, mySQL etc are fine.
Hope this helps,
Markus
[1] I have made an Addons script for this:
http://grass.osgeo.org/wiki/GRASS_AddOns#db.join