>DELETE MyTable; > FROM MyTable; > JOIN MyCursor ON MyCursor.Id = MyTable.Id > >UPDATE MyTable; > SET SomeField = SomeValue; > FROM MyTable; > JOIN MyCursor ON MyCursor.Id = MyTable.Id >>
>>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) >> >>>>