--- In firebird-support@yahoogroups.com, "Tanz Anthrox"
<tanz_anthrox@h...> wrote:

> Hi,
>
> I have two seperate Query running on client side.
> one is like
>
> FIRST QUERY=
>
> select * from Members;
>
>
> other is SECOND QUERY=
>
> select A.Amount,M.Ad||' '||M.Soyad
> from Aidat A, Members M
> where A.Kod = M.Kod
>
>
> When I try to scroll the records in second query, First Query also

scrolls.

>
> Is it normal Behaviour of Firebird. Or Do I need to learn more :)

Any scrolling is determined by your client, not by Firebird itself.
The automatic scrolling may be a result of some master-detail
operation by whatever components you use. No-one can answer you
without knowing more about which components you use. Most likely this
is also a question suitable for a group for those components rather
than ib-support.

> And, Does Second Query equals with INNER JOIN?

Yes, it is the same as an inner join, just written with an older
syntax (SQL-89). It is not as powerful as using join, and also poses
some extra challenges for you - e.g. with IBO you have to fill in
JoinLinks if using the above syntax, something which is redundant when
using join.

Set