Hi list,
I am not sure if such complex join has been asked on the list, but I did
not find a similar problem in the archive.
Here are my tables
Table1 Table2
fid (pk) srcfid(pk)
name fid(fk) <- references Table1.fid
start
stop
The SQL query I'd like to translate with DBIx is the following
SELECT * FROM Table1 nt1, Table2 nt2, Table 1 mt1, Table2 mt2
WHERE nt1.fid=nt2.fid AND mt1.fid=mt2.fid AND mt2.srcfid=nt2.srcfid
..... other where conditions.
So my question is, does someone would know how to translate the
particular WHERE clause (mt2.srcfid=nt2.srcfid) ?
Thanks in advance for any clue.
If this is not possible, I'll move to literal SQL using $dbh and $sth.
Regards
Emmanuel
--
-------------------------
Emmanuel Quevillon
tuco at_ pasteur dot fr
-------------------------
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk