I need to realize this query in DBIx - but it's no things in newbie head how to 
do it...

SELECT net_name, COUNT(node_id) as dev_count
FROM [dbo].[networks] nw
LEFT JOIN nodes nd ON nw.net_id = nd.net_id
GROUP BY net_name

result:
net_name   dev_count
--------   ----------
net1        7


----
dr.eel

_______________________________________________
List: http://lists.rawmode.org/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/[EMAIL PROTECTED]

Reply via email to