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
IT SHOULD WORK:)
update table1
set flag = 1
where [in]=[OUT]
update table1
set flag = 0
where [in]<>[OUT]
hope it helps.
regards,