m.SearchValue = 1 m.SomeValue = 1 UPDATE MyTable; SET SomeField = m.SomeValue ; where SomeValue = m.SearchValue DELETE FROM MyTable WHERE SomeValue = m.SearchValueCetin
>SELECT *; > FROM MyTable; > WHERE SomeValue = 1; > INTO CURSOR MyCursor >>
> > UPDATE MyTable; > SET SomeField = SomeValue; > WHERE Id IN; > (SELECT Id FROM MyCursor) > > ** OR > > DELETE FROM MyTable; > WHERE Id IN; > (SELECT Id FROM MyCursor) > >>