HI!
I made a litle program to test this.

----- Original Message -----
From: Svein Erling Tysvaer
To: ibobjects@yahoogroups.com
Sent: Saturday, February 10, 2007 6:31 AM
Subject: Re: [IBO] Column does not belong to referenced table - Bug report


Your original query did not alias the subquery, I think that's what made
Helen say it isn't legal SQL. However, the statement below does alias
the subquery and seems like legal SQL. If it is reproducable in the last
beta version of IBO, I'm sure Jason would be happy to receive a simple
test case (a test case that either uses tables that are available to all
or that builds the tables on startup) clearly showing your problem (then
he can tell whether it is actually an error or some misunderstanding).

I'm surprised that it seems like the below SQL doesn't generate the PK
of folha as its KEYLINKS, but tries to go RDB$DB_KEY. The only not quite
normal with the SQL, is that the subselect selects C.pk_tb_fpg_cod and
not * or a constant, but that shouldn't matter.


.


[Non-text portions of this message have been removed]