Re: Help! Very complex SQL statement required.
My prior message is not correct. In fact, just the second query is
enough. What I was really thinking is about to have different kinds of
accounts and list banks without firms. Sorry for my mistake.
The second query with some little modifications is enough:
>Query #2
>Select B_ID, Count( Distinct F_ID ) As QtFirms
> From Accounts
> Group By b_id>
I also forgot that BDE (at least D2 developer) doesn't support numbers
in group by clause.
EBR