At 08:01 AM 13-11-02 +1100, you wrote:

> > 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...
> >

Some older versions of query tools may not do the right thing in counting
the number of rows fetched, especially from joined queries. It has never
been an especially reliable thing in any case. I believe the area of
row-counting across the client/server interface is being looked at with a
view to re-implementing for a future version of Firebird.

One thing I do see that is wrong with your query is the use of double
quotes to delimit strings. This was possible in older InterBase
versions; it is now wrong syntax in IB6 and Firebird. Use ONLY single
quotes for strings.

heLen