Subject Re: [firebird-support] Re: Optimizing a count query
Author Kjell Rilbe
dinol.softedge wrote:
> What I really want is this. The query must always show 1 master
> record irrespective of the number of detail records but there must
> also be a row that shows whether there are details records such as a
> boolean field. The count is not important. Does this make sense?

This is what I've been trying to answer.

But you made a typo. You meant "there must also be a *column* that
shows...". Right?

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