--- In firebird-support@yahoogroups.com, Zsolt Balanyi <zsolt.balanyi@...> wrote:

>
> Hi Karol,
>
> the same A2.ID is linked to multiple records that fulfill both first and
> second criteria. This way you DO get 210 matches, but they are only 207
> DISTINCT ID-s.
>
> Regards, Zsolt

Hi

i delete this message on yahoo - but this is e-mail also list and you see it ;-)
i found problem after sending this message and of course you have right but in my situation this table should not have more then 1 record (should contain unique constraint and 1=1 relation) and becouse of that i wasn't able to see problem at start

Karol Bieniaszewsi