Roger,
This statement runs but the table isnt actually updated. Slightly odd.
I ran the subquery, which makes perfect sense and nothing was
returned. If I remove the AND temp.id <> junctions.id part I get loads
of results returned but if I run the update with the the adjusted
subquery I get ERROR:
On Apr 23, 4:25 am, Iain Adams <[EMAIL PROTECTED]> wrote:
> 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.
