Subject | Scrolling behaviour in JOIN |
---|---|
Author | Tanz Anthrox |
Post date | 2003-10-22T14:52:31Z |
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 :)
And, Does Second Query equals with INNER JOIN?
Regards,
[Non-text portions of this message have been removed]
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 :)
And, Does Second Query equals with INNER JOIN?
Regards,
[Non-text portions of this message have been removed]