如何在连接后获取具有相同列名的属性（Symfony框架与Propel）？

Question

I have two tables:

Table1:

• id
• attr1
• fk1(Table2)
• fk2(Table2)

Table2:

• id
• name

I want to join Table1 with Table2 on fk1 and fk2. How can I do this two joins and after that get both name attributes from Table2. I would like to do it with Table1Query rather than Table1Peer.

Answer 1

Take a look at my answer to this question: Naming Generated Functions in Propel

Since you have two foreign keys that point to the same table, you need to utilize the "phpName" attribute on the "foreign-key" element.