--- In firebird-support@yahoogroups.com, "Dan Wilson" <dwilson@d...>
wrote:

> 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.

I have a table Match in which each match has two teams. The teams are
stored on the Team table. When I get one match, I need to get the
names of both teams.