Sergio H. Gonzalez wrote:

> 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';

Why don't you just give it a try?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64