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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
