SQL Node Update statement

[cognosjon]

Scratching my head on this one.

I've a need to test two columns within a table that have the same ID and update a flag if the two data columns do not match. so for example:

ID           IN                OUT        Flag
1            100             100            0
2            200             200            0
3            200             300            1

I'm running on Oracle and I've tried to use a sql node with the following code but it doesn't like.
Has anyone any other ideas as to how best to approach this. Can I do it without a SQL node??

update table1 a
set a.flag =1
(select a.ID a.IN, a.OUT, b.ID, b.IN, b.OUT
from table1 a, table1 b
where a.ID =b.ID and a.In<>b.OUT)


Thanks in advance

[raven31]

IT SHOULD WORK:)

update table1
set flag = 1
where [in]=[OUT]

update table1
set flag = 0
where [in]<>[OUT]


hope it helps.

regards,