Querey building problem

[Niniel]

Hello,

I have a query where I would like to include names from a name table. The problem is that I get this "ambiguous outer joins" error when I try to include it in my query.
I have a main table, the name table, and a join table with the IDs from both of the other two tables in order to model a many-to-many relationship between main table and name table.

Is there a way around this?

Right now the query contains the main table and the join table so I get the name ID, just not the real names.

Thank you.

 

[FoFa]

make sure if your name Xref table is outter joined, you outter join the name table to your Xref table the same direction. basically

 

[Niniel]

Oh, yes, of course!
Thank you very much.
I guess it was just too obvious.