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: more than one row returned by a subquery used
as an expression. Dont quite know what is going wrong.
Thanks alot
Iain
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
