> I am new to Firebird (and SQL as you will guess by my question)...
>
> I am using the following select statement:
>
> select * from GDTH JOIN GDTT ON GDTH_KEY = GDTT_PARENT where GDTH_KEY =
> "SCHL"
>
> There are 3 matching records, but my query only returns 1.
>
> When I try the query in IBAdmin, it shows the 3 records in the results
> window, but says that only one record was fetched.
>
> If I then repeat the query, all records are fetched...
>
> What am I missing?
>
> TIA