Hi,
have trawled through the docs and Googled but still cannot fathom how to do
this in DBIc::Class
SELECT test_result_idFROM (SELECT MAX(created_at) AS latest,
pdt_revision_fk,
test_revision_fk
FROM test_wide_fact
WHERE (( test_wide_fact.ignore_result = false
AND test_wide_fact.pdt_revision_fk IN (
1729554724791742389 ) ))
GROUP BY pdt_revision_fk,
test_revision_fk) ltst
JOIN test_wide_fact
ON ltst.latest = test_wide_fact.created_at
AND ltst.pdt_revision_fk = test_wide_fact.pdt_revision_fk
AND ltst.test_revision_fk = test_wide_fact.test_revision_fk;
I cannot see how to select from a select and then do a join, if anyone could
point me to some examples then I'd be grateful!
Allan
_______________________________________________
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/[email protected]
