This might help https://metacpan.org/module/DBIx::Class::Manual::Joining#Joining-to-the-same-table-twice
-siddhartha On Thu, 30 Aug 2012, Emmanuel Quevillon wrote: > On Wed Aug 29 14:47:06 2012, Hailin Hu wrote: > > you can try to define a self-reference has_one relationship on Table > > 2, and use the relationship in join. > > you can't join tables without relationship defined. > > > > On Wed, Aug 29, 2012 at 5:57 PM, <t...@pasteur.fr> wrote: > >> 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 > > Hi Hailin, > > I'll try this and let the list know. > Thanks for your advice. > Emmanuel > > -- > ------------------------- > Emmanuel Quevillon > CIB, Centre Informatique pour la Biologie > Institut Pasteur > +33 1 44 38 95 98 > 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 _______________________________________________ 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
