hello, I think this is a very old question, but I've been googling with no luck
(probably I'm not using the right search keys?)

Is this OK with FB2.1? Is there any other better way to do it? I have a
master/detail table and I want to delete all the details from some kind of
movement, but the kind of movement field is in the master table:

DELETE FROM DETAIL
WHERE
(SELECT KIND_MOV FROM MASTER
where MASTER.id = DETAIL.id) = 'SOME VALUE';


Thanks