You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Fedor Karpelevitch <fe...@Barra.COM> on 2001/11/02 16:16:34 UTC
RE: criteria hell
In this case just do not use Criteria. Why do you need to?
fedor.
-------------------------------
The Joy of CVS
> -----Original Message-----
> From: Nick Pomfret [mailto:nick.pomfret@pixelpark.com]
> Sent: Tuesday, October 30, 2001 10:02 AM
> To: Turbine Users List
> Subject: criteria hell
>
>
> Can someone please help me turn this SQL into a Criteria object?
>
> select
> x.id,
> max(x.some_column)
> from
> table_x x,
> table_y y,
> where
> (y.blah < x.blah
> or y.blah is null )
> and x.id = y.id
> group by
> x.id;
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>