Thanks Fou-Lu. That's a great piece of advice.
I have one scenario though, which I'm stuck on then. I have 'table_a' which contains a number of entries and a column called 'id' and another column called 'is_set' which contains a value of 0 or 1.
I wish to find all the Id's in 'table_a' which have a value in 'is_set' of 1
Then UPDATE a different table 'table_b' which also has the columns 'id' and 'is_set' finding each of the entries where table_a.id = table_b.id
So best way I can think of doing this would be in a loop, which is why I asked the question. Is there therefore. Better way of handing this?
Last edited by Oatley; 12-11-2012 at 09:00 AM..