4
Is there any way to search two fields (in different tables), compare them and if they are different perform an update? Could you give me a brief example if there is any way, using the EXECUTE BLOCK
.
4
Is there any way to search two fields (in different tables), compare them and if they are different perform an update? Could you give me a brief example if there is any way, using the EXECUTE BLOCK
.
1
Something like that:
execute block
as
begin
IF ( (select numero from btr01 where numero=150000) = (select numero from btr01 where numero=150001))
THEN update btr01 set serie='123' where numero=150000;
ELSE update btr01 set serie='321' where numero=150001;
end
Browser other questions tagged sql firebird
You are not signed in. Login or sign up in order to post.
this solved that question ?
– SneepS NinjA