On 3/9/2005 at 5:37 PM Ricardo wrote:

> I have a table which has two fields that are foreign keys of the same
> table. I need to make an inner join with the referenced table but
> when I run the query, the result contains the same data for both
> fields.
>
> I used to solve this problem in other databases by just renaming the
> referenced table on the inner join clause. It seems this doesn't work
> on Firebird. How can I do that?
>

Can you show us an example of what you are trying to do?

Dan.