Hi,
This is probably a really easy question but I have been toiling with
this SQL for ages.
Okay I have a table with geom_id and id in, this table is called temp.
I also have another table called junctions with a column, old_id. Now
old_id corresponds to geom_id. I want to update the junctions table
column id with the id held in temp where the geom_id column matches
the old_id column.
I would really appreciate some help on this. I just cant seem to get
it right.
Thanks
Iain
