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?