On Tue, Sep 22, 2009 at 7:23 AM, Oleg Kostyuk <cub.ua...@gmail.com> wrote: > I think, you just need to join twice with tags table, and this will > give you what you want:
And if you need products which have 3 or more tags? One join per tag? It is not ideal. -- wallace reis/wreis Catalyst and DBIx::Class consultancy with a clue Software Engineer and a commit bit: http://shadowcat.co.uk/catalyst/ Shadowcat Systems Limited http://www.shadowcat.co.uk http://www.linkedin.com/in/wallacereis _______________________________________________ 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