Re: [Dbix-class] Joins with circular relations

2007-10-04 Thread Bernhard Weisshuhn
On Wed, Oct 03, 2007 at 11:51:05PM +0100, Matt S Trout [EMAIL PROTECTED] wrote: On Wed, Oct 03, 2007 at 06:17:54PM +0200, Bernhard Weisshuhn wrote: [...] SELECT translatedwords.translatedword FROM userwords JOIN users ON (users.user = userwords.user) JOIN

Re: [Dbix-class] Joins with circular relations

2007-10-04 Thread Matt S Trout
On Thu, Oct 04, 2007 at 10:16:41AM +0200, Bernhard Weisshuhn wrote: On Wed, Oct 03, 2007 at 11:51:05PM +0100, Matt S Trout [EMAIL PROTECTED] wrote: On Wed, Oct 03, 2007 at 06:17:54PM +0200, Bernhard Weisshuhn wrote: [...] SELECT translatedwords.translatedword FROM

[Dbix-class] Joins with circular relations

2007-10-03 Thread Bernhard Weisshuhn
Hello everbody, I'm pulling my hair on this one. I'm trying to specify a query where the join criteria of one nested table refers to a table already joined. No problem in SQL, but I can't seem to do it in DBIC-Syntax. It's kind of hard to explain for, so please take a look at this example (which

Re: [Dbix-class] Joins with circular relations

2007-10-03 Thread Matt S Trout
On Wed, Oct 03, 2007 at 06:17:54PM +0200, Bernhard Weisshuhn wrote: Hello everbody, I'm pulling my hair on this one. I'm trying to specify a query where the join criteria of one nested table refers to a table already joined. No problem in SQL, but I can't seem to do it in DBIC-Syntax. It's