Jason Dodson wrote:

> Isnt one of the goals of Firebird to be IB6 compatible? Or was that just
> originally?>
>

Yup. But we don't control the development of IBX or its continuing
compatibility with what is now a very old version of InterBase. And we
do make exceptions when legal InterBase V6 statements are ambiguous and
can return unexpected results.... to quote from a recent example...


select S1.userid, S1.groupid, S.username
from S
inner join S S1 on
S1.userid=S.userid
where S.groupid='004'


Regards,

Ann