Subject Re: [firebird-support] Query help
Author Kjell Rilbe
Den 2012-07-22 22:35 skrev Ricardo Uzcategui såhär:
> Maybe if you do a join...
> like this...
> select m.* from master m
> join detail d
> on ( = d.master)
> where (d.removed is not null)

Thanks for trying, but that would return all master records where there
is at least one detail that's not removed. Instead, I need all the
masters where there are removed details, but no current ("unremoved") ones.


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