You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@turbine.apache.org by Joel Hockey <jo...@qsipayments.com> on 2002/01/23 03:29:12 UTC

select count(*) with criteria

Does the peer/criteria model support selecting counts on a table?

My sql is:
select t1.id, count(t2.id) from table1 t1, table2 t2 where t1.id = t2.id
group by t2.id

I'm actually quite happy to just use sql like I am currently doing, but I
would be interested if someone else could suggest a better way to do this.

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>